Cells section in Sheets

 

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).

Was this article helpful?

1 out of 7 found this helpful

Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.