Right-click on tab and select Tab Color.
Cycle through open spreadsheets
Hold CTRL while hitting Page Up and Page Down (in Macs hold Fn also) and you can go from one sheet to the next.
Shortcut to view formulas
Ctrl+` (the accent grave is just to the left of the 1 key and above the Tab key.) Ctrl+` is a toggle, so it can be used to switch between the display of formulas and results.
Freeze Panes
Freeze panes (2010). You may want some rows or columns to stay in a fixed position, especially if your worksheet is very large. View->Freeze Panes->Freeze Top Row or First Column.
Split the Worksheet
To view and scroll independently in different parts of a worksheet you can split into vertical and/or horizontal panes. This will enable you to click inside any one pane and scroll to locate information in that pane while the other panes remain in place. Move your curser to drag a split box (the small box […]
Hide data before printing.
To hide a column(s) select and press Ctrl+0; to hide a row(s) select and press Ctrl+9. To hide data within cells: Change the font colour to white.
Protecting formulas in an unprotected sheet.
Firstly select all cells containing formulas in a worksheet:1. Press F5.2. Click Special, and then select the Formulas option.3. Click OK. Secondly validate data:1. Ensure cells remain selected (e.g. don’t click in the worksheet to deselect).2. From the Data tab (menu), select Data Validation or Validation…3. Select the Settings tab, and select Custom from the […]
