If you inherit an Excel spreadsheet, how do you figure out how the spreadsheet works? For example, how do you determine where all the formulas are or how the data is calculated?
You could click on each cell and look in the formula bar. However, that could be time consuming and tedious. And that method doesn’t give you a clear picture of how the whole spreadsheet is setup. It only allows you to view the formulas, one cell at a time.
Excel provides 2 quick methods to display all formulas at once within a worksheet.
Method A: Show Formulas icon
1.
Open the Excel spreadsheet that you want to figure out
2.
Go to the Formulas tab, in the Formula Auditing group, click the Show Formulas icon
Each column automatically gets wider and Excel displays all the formulas in the entire worksheet.
3.
Click the Show Formula icon again, to hide all formulas
Method B: Keyboard Shortcut: Ctrl + `
1.
Open the Excel spreadsheet that you want to figure out
2.
Press Ctrl + ` (Grave Accent) on your keyboard
On most keyboards, the ` (Grave Accent) is just below the Esc key (top left hand corner of your keyboard).
Each column automatically gets wider and Excel displays all the formulas in the entire worksheet.
3.
Press Ctrl + ` (Grave Accent) on your keyboard again, to hide all formulas.
Please share this with other Excel users and give them a quick way to determine how a spreadsheet is setup.
~ Let Microsoft Excel do the work for you. ~
0 Comments