After about 2-3 minutes Voila I found this.
Under Formulas Tab -- There was Show Formulas button in the Formulas Auditing Group as shown below. This button works as a toggle for showing and hiding the formulas.
Tuesday, February 01, 2011
Print formuals from Excel 2007
Yesterday I had a requirement to compare formulas between two sheets. So I wanted to print the formulas and compare. This is a basic feature but I straight away did not know how to do it. So I started investigating the ribbon in Excel 2007.
After about 2-3 minutes Voila I found this.
Under Formulas Tab -- There was Show Formulas button in the Formulas Auditing Group as shown below. This button works as a toggle for showing and hiding the formulas.
After about 2-3 minutes Voila I found this.
Under Formulas Tab -- There was Show Formulas button in the Formulas Auditing Group as shown below. This button works as a toggle for showing and hiding the formulas.
Subscribe to:
Post Comments (Atom)
Create a New Partition on existing multi-dimensional SSAS cube.
Below is a process that I follow every year to create a partition in existing multi-dimensional SSAS cubes that I maintain. Log in to t...
-
This morning I was trying to call a stored procedure and insert the results in a temp table using the following code -- create table #...
-
Did you ever have a situation where you felt like converting a Sql Server Analysis Services in Multidimensional Mode to Tabular Mode ? ... -
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...
No comments:
Post a Comment