Excel has three levels of worksheet visibility: visible, hidden, and very hidden. While many people know about hiding and ...

Alternatively, if you prefer using Microsoft Excel keyboard shortcuts, press Ctrl+Page Down or Ctrl+Page Up to navigate to ...

Launch Microsoft Excel and then press "Alt-F" to switch to the File tab. Select "Options" from the menu, and then select "Manual" from under Calculation Options on the Formulas tab.

(The tabs above the Ribbon — File, Home, Insert, and so on — stay visible.) To make the commands reappear, press Ctrl-F1 again or click any tab name. You’ve got other options for displaying ...

To do so, click the "File" tab in the ribbon menu, then click "Info." Then, click "Protect Document" and choose one of the options presented. Clicking "Always Open Read Only" will ensure that the ...

If you're using Excel offline, or just prefer to take a more direct role in deleting the cache, the process is a little longer, but still fairly simple. Switch to the File tab in Excel. Click Options.

This sheet-level option suppresses 0s. SEE: Learn how to enter leading zeros in Excel. There are no visible zero values. They’re still there, but the entire Excel sheet is suppressing their display.

Excel also allows you to apply more customized security options to your file if necessary. It’s important to know what these other options do so you can create the right security for your project.