Excel tip: Show formulas with a keystroke

Excel formula viewI've been using Excel for a long time and might even consider myself a power user, so I'm surprised I never came across this tip before: You can toggle a formula view to see all of a spreadsheet's formulas at once by pressing Ctrl+`. That little fleck, in case it's not entirely clear, is a backtick (or, as this site takes way too many paragraphs to explain, a gravé), i.e. the seldom-used character that shares a key with the tilde just to the left of the 1 key on most keyboards. Press Ctrl+` once to show all of your formulas, press it again to switch back to the regular data view.

source post [Digg]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: