Instantly displaying all worksheet formulas


show more Instantly displaying all worksheet formulas provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Instantly displaying all worksheet formulas

If you are viewing a worksheet that you are not familiar with, one of the things you need to know in some worksheets is where are the formulas and what are they? Now on a cell-by-cell basis, we might click for example on cell B7. We can see on the formula bar. Of course, that is a formula, but that's going to be a little tedious. We might want to actually, see the formulas in the cell. There is a command for this: It's on the Formulas tab. It's called Show Formulas. We can click this. Look what happens. And by the way, note the keystroke shortcut, which we'll get to in a second, it's going to be faster than this, but Show Formula does what? It doubles the width of all columns as it exposes formulas.

It also left aligns other data. Sometimes that tab isn't present, so getting back to here is noise as fast as it might be. What's this control business and what's that shortcut that we up there? You can barely see it. Right here on the screen, I've put this here...

Instantly displaying all worksheet formulas
Video duration: 3m 16s 3h 43m Intermediate

Viewers:

Instantly displaying all worksheet formulas provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...