Little Known Excel Shortcut #5
By BankersBall on Jun 20, 2006 in Excel, Excel Shortcuts, Tools
Because a picture is worth a thousand formulas.
 |
SHORTCUT:
Hit Ctrl + ~
PURPOSE:
See formula view (instead of value view)
FURTHER EXPLANATION:
Toggle quickly from seeing the values of the cells in your spreadsheet to the underlying formulas (if any.) If a cell is just a value, then it will appear the same.
On Jun 20, 2006, mj said:
little-known my ass
On Jun 20, 2006, nj said:
i didn’t know it.
On Jun 20, 2006, anallust said:
Then you probably weren’t a banker or have no modelling experience
On Jun 20, 2006, Anonymous said:
how bout just pressing the F2 button. no need to hit two buttons at once. n00bs.
On Jun 20, 2006, BankersBall said:
well F2 only shows you the formula in one cell, this shows you all the formulas in the entire tab.
On Jun 30, 2006, nj said:
Annallust, good luck on your life-long career as a tool, punching CTRL+~ over and over again. I bet you’re one of those douche bags that brags to his friends about not using the mouse. Also, an ‘analyst’ is not a banker. An analyst is a monkey. Don’t forget it.
On Jul 10, 2006, anallust said:
Wow NJ i’m sorry your bank didn’t give you the experience 99% of anyone who has ever built or audited a model would have… you’re douchebag assertion is funny…just because I pointed out your glaring idiocy doesn’t mean I’m a douchebag…I would say its similar to saying to someone who works in starbucks not knowing how to make a latte (bad example) but you get the point…Oh and btw I left banking a while ago…off to greener pastures if you get my drift
On Oct 13, 2008, Tom said:
This doesn’t work on a UK keyboard. It is ctrl + ` for UK.