Cells section in Sheets

• Cells section in Sheets Windows

Cells section in Sheets Windows

The Cells section contains options to manage cells, rows, columns, and sheets.

Insert – Adds new cell(s), row(s), column(s,) or sheet(s):

	Shift Cells Down – Inserts a new cell at the selected location, shifting any current cell data down.
	Shift Cells Right – Inserts a new cell at the selected location, shifting any current cell data to the right.
	Insert Rows – Inserts a new row above the current selection.
	Insert Columns – Inserts a new column to the left of the current selection.
	Insert Sheet – Adds a new sheet to the spreadsheet.

Delete – Deletes the currently selected cell(s), row(s), column(s), or sheet(s).

	Shift Cells Up – Deletes the currently selected cell(s) and shifts any cells with data upwards.
	Shift Cells Left – Deletes the currently selected cell(s) and shifts any cells with data to the left.
	Rows – Deletes the currently selected row(s) and shifts any rows with data upwards.
	Columns – Deletes the currently selected column(s) and shifts any columns with data to the left.
	Delete Sheet – Deletes the current sheet.

Format – Provides advanced customizations for how your spreadsheet is displayed.

	Row Height... – Specifies the row height for the selected cell(s).
	AutoFit Row Height – Automatically scales the row height to fit the contained data.
	Column Width... – Specifies the column width for the selected cell(s).
	AutoFit Column Width – Automatically scales the column width to fit the contained data.
	Hide & Unhide – Provides options for hiding and unhiding rows, columns, and sheets:

	Hide Rows – Hides the currently selected row(s).
	Hide Columns – Hides the currently selected columns(s).
	Hide Sheet – Hides the currently selected sheet.
	Unhide Rows – Unhides and neighboring hidden row(s).
	Unhide Columns – Unhides any neighboring hidden column(s).
	Unhide Sheets... – Displays the Unhide Sheets dialog, which allows you to specify which sheets are displayed.

	Rename Sheet – Renames the currently active sheet.
	Tab Color – Inserts a color into the spreadsheet tabs at the bottom of the page.
	Protect Sheet... – Opens the protect sheet dialog, which allows you to apply editing restrictions. Note that restrictions are applied to the current sheet only and protect passwords are not recoverable!
	Lock Cell – Marks the selected cell(s) as locked to prevent them from editing.
	Format Cells... – Displays the Format Cells dialog, which allows you to apply custom to the selected cell(s).