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)
Step By Step Guide to resolve SQL server connection issues when connecting from R Studio
Yesterday I tried using a couple of RevolveScaleR functions -- RxSqlServerData and RxImport.in Rstudio. These are my learnings as part of ...
-
I needed to convert some vbscript to javascript as firefox doesn't support vbscript. I found this online tool very helpful Beware tha...
-
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...
-
The following features cannot be saved in macro-free workbooks VB Project To save a file with these features, click no, and then choose ...
No comments:
Post a Comment