Best Microsoft Excel Bloggers

Friday, March 16, 2012

New Keyboard Shortcut

I have been woefully behind on this blog due to family illness and upgrading so I apologize to people who have left me questions however I will get them all answered shortly. will be down March 17and March 18 as the site is upgraded and shopping cart changed. I can't wait for this to be finished :)

Meanwhile - A quick tip.
Display Formulas with Keyboard Shortcut
This one was new to me and I have to thank Francis, the ExcelAddict, for it.
If you have a large spreadsheet with a lot of formulas, a really quick way to display them is to simply Press the Control key and the tilde button. The tilde button is the upper left of the keyboard and looks like this: ~
Press Ctrl and ~ together and your formulas will display. It works as a toggle.
If you have long formulas, you will need to widen the columns to see the formulas and then manually return them to their previous width.

Have a great St. Patrick's Day!

Ms. Excel- Resident Excel Geek