Format tab in Sheets

Format tab in Sheets iOS

The Format tab is a quick way adjust the formatting of the various elements of your spreadsheet. This also includes options to adjust units of measurement and cell alignment.

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.

Was this article helpful?

0 out of 0 found this helpful