Sheet Tab Context Menu

The sub menu contains command that applies directly to the selected sheet.

To access this command...

Right-click on the sheet tab in the sheet navigation bar.

Insert Sheet

Defines the options to be used to insert a new sheet. You can create a new sheet or insert an existing sheet from a file.

Deletes the current sheet or selected sheets.

This command opens a dialogue box in which you can assign a different name to the current sheet.

Duplicates the selected sheet assigning a new name.

Moves or copies a sheet to a new location in the document or to a different document.

Selects all of the sheets in the current spreadsheet.

Protects the cells in the current sheet from being modified.

Displays sheets that were previously hidden with the Hide Sheets command.

Hides the sheet.

Toggle the visibility of grid lines for the current sheet.

Opens a color selector window where you can assign a color to the sheet tab.

Assigns macros to program events. The assigned macro runs automatically every time the selected event occurs.