With the active cell anywhere in a worksheet, press control+~ (tilde) - do not use the shift key. All column widths in the current worksheet are now twice as wide, and all formulas are displayed instead of their results. This shortcut acts as a toggle - press it again and the display returns to normal.
- [Voiceover] We're looking at a worksheet called formulas and it's a bit of a mess. It's got viable information in it, it's got lots of formulas in it, and we're trying to figure out what's going on and would be really helpful if we could see the formulas. If you ever looked at a worksheet like this you get the habit, probably, of clicking on different cells saying, well that's a formula, that isn't and so on and as you start to scope this out and figure out what's going on, I think often you would say, I'd like to see all these formulas. We can certainly see the formula on a given cell and we can double click maybe and see it even better here but to see all formulas in the worksheet at once, hold down the control key and click one of the keys that you see right here and most keyboards in the United States, this is in the upper left hand corner it tends to be between the tab and escape keys usually to the left of the number 1 key.
That symbol on top is frequently called tilde, it's a character that you see over the letter N in some words in spanish, you also see it over some letters in Portuguese as well too and perhaps some other languages as well. Now, do not use the shift key but hold down the control key and click that key. I'll call it tilde, CTRL+Tilde. Remember, no shift key, and what happens? All worksheet column widths are doubled but more important, wherever there is a formula, for example in cell B7 and in D13, E13, we see the actual formula instead of the results.
The other displays look a little bit unusual as well, numbers are left aligned so are text, so it certainly has a different look. This is what we call a toggle switch, press CTRL+Tilde again, we're back to normal so it's really handy to get a quick read. Now, as we're viewing this here we're not seeing the results in those cells we're seeing the formulas so you have to think of it as displaying formulas or results. Again, back and forth anytime you wish. It wouldn't be a bad idea in some situations too when the screen is looking like this.
Click on the upper left hand corner, double click a column boundary, and then possibly, maybe manually, adjust some of these too but then perhaps print this, use it as a source of documentation. You might want to experiment with those column widths again. Now, a quick print preview here by way of CTRL+P will give you some sense of what this looks like. You might want to make some other changes and show the actual grid lines before printing this. This is certainly not a necessity but it might be helpful if you're trying to provide some documentation for a worksheet like this.
Now if you have readjusted the column width for this view, when you press CTRL+Tilde and go back to normal, you probably want to reconsider those column widths again, clicking on the upper left corner, double clicking a column boundary, and now more or less back to the view that we first saw. So remember, seeing formulas like this is really handy, it's CTRL+Tilde, and it's analogous to another feature you'll find on the formulas tab in the ribbon you'll see a choice off to the right, Show Formulas. Click it, see the formulas, click it, we're back again.
Really handy for worksheet troubleshooting, great keystroke shortcut, analogous to the same command called show formulas found in the formulas tab.
The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "Ten Tiny Tips" chapter for a quick productivity boost.
- Entering today's date or time instantly
- Converting formulas to values with a simple right-drag
- Undoing and redoing with keyboard commands
- Creating split screens fast
- Navigating in workbooks quickly
- Selecting noncontiguous ranges
- Entering data more efficiently
- Applying formatting with keyboard shortcuts
- Accelerating copying and moving data with drag and drop
- Creating formulas rapidly
- Using database techniques to work with Excel data
- Working with charts, shapes, and linked images