How to Display or Hide Formulas in Microsoft Excel

When working in Excel, you often need to review formulas.

But it can be tedious to click into each cell to check them individually.

How about seeing them all at once?

You can with this simple trick.

Press and hold the Ctrl+` keys.  The grave accent key is usually paired with the ~ key near the top left of a qwerty keyboard.

Press the keys again to hide the formulas.

Check out the cool Excel and Microsoft Office tips below.

Listen to the One Cool Tech Tip Show

Podomatic | Tunein | PlayerFM | Stitcher | iTunes

READ MORE

• Select an Entire Excel Spreadsheet
• Use This Keyboard Shortcut to Access the Ribbon menu in Microsoft Office Products
• Total an Excel Column Faster With This Keyboard Shortcut
• Tell Outlook Where to Search
• Select an Excel Data Set Faster with this Shortcut
• This Power Point Tip Will Make You the Focus
• Show or Hide Microsoft Word Format Marks
• Microsoft Words Magical Lorem Ipsum Generator

OneCoolTip.com

http://www.onecooltip.com
Facebook | Twitter | Google+ | One Cool Tip Show

Cool Tech Tips for a Cooler Life!

#Microsoft #Excel #formula