 |
Number Formatting – Allows you to mark numbers in cell ranges, and choose from a wide range of unit measurements and formatting. |
 |
Cell Font – Changes the formatting of cells and cell ranges. Besides horizontal and vertical alignment, you can adjust font size, style, color, indentation, and more. |
 |
Cell Border – Provides options for specifying cell borders on cells or cell ranges. |
 |
Cell Style – Allows you to customize your cells from a selection of available built-in themes. |
 |
Cell Protection – Allows you to lock cells or hide formulas in them. Note that these setting take effect only in protected sheets (you can make a sheet protected from the Review tab). |
 |
Hide Rows – Hides (but does not delete) cell rows from view. Hidden rows are marked by a Red arrow along the row number column, and can be shown using Unhide Rows. |
 |
Unhide Rows – Reveals hidden rows. Can only be accessed from selected neighboring unhidden rows. |
 |
Auto-Fit Rows – Rezises rows to fit the character width of their data. |
 |
Hide Columns – Hides (but does not delete) cell columns from view. Hidden columns are marked by a Red arrow along the column letter row, and can be shown using Unhide Columns. |
 |
Unhide Columns – Reveals hidden columns. Can only be accessed from selected neighboring unhidden columns. |
 |
Auto-Fit Columns – Rezises columns to fit the character width of their data. |
 |
Rename Sheet – Renames the individual sheets of your spreadsheet. |
 |
Tab Colour – Distinguish your tabs from one another by inserting different colours to them. |
 |
Conditional Formatting – Opens the conditional formatting dialog, which provides options to highlight cells and cell ranges based on certain criteria. |
 |
Edit Hyperlink – Used to add or edit a hyperlink in the selected cell or cell range. |
 |
Clear – Clears the contents of a cell or cell range. Also allows you to selectively clear just formatting, contents, comments, or hyperlinks. |