Format tab in Sheets

• Format tab in Sheets Android
• Format tab in Sheets iOS

Format tab in Sheets Android

The Format tab is a quick way adjust the formatting of the various elements of your spreadsheet. This includes common formatting options from other tabs, as well as 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. Each category provides additional customization options, while the Custom category allows you to specify your own number format.
	Alignment in Cell – Changes the formatting of cells and cell ranges. Besides horizontal and vertical alignment, you can adjust indentation and more.
	Cell Font – Changes the formatting of cells and cell ranges. You can adjust font size, style, color, and specify text effects.
	Borders – Opens the cell border dialog, which provides options for specifying cell border colors and line styles.
	Hide Rows – Hides (but does not delete) cell rows from view. Hidden rows can be shown using Unhide Rows.
	Unhide Rows – Reveals hidden rows. Can only be accessed from selected neighboring unhidden rows.
	Auto-Fit Rows – Automatically expand to fit the largest value in the selected row.
	Hide Columns – Hides (but does not delete) cell columns from view. Hidden columns can be shown using Unhide Columns.
	Unhide Columns – Reveals hidden columns. Can only be accessed from selected neighboring unhidden columns.
	Auto-Fit Columns – Resizes columns to fit the character width of their data.
	Rename Sheet – Renames the individual sheets of your spreadsheet.
	Duplicate Sheet – Select a specific sheet and create a duplicate of it.
	Tab Color – Paint your sheet's tab (bottom of the screen) in a specific color.
	Conditional Formatting – Opens the conditional formatting dialog, which provides options to highlight cells and cell ranges based on certain criteria.
	Edit Hyperlink – can be used to add or edit a hyperlink in the selected cell or cell range.
	Clear – Clears the contents and formatting of a cell or cell range.

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.