How do I apply the same format to all sheets in Google Sheets?

A Google spreadsheet can contain one or more sheets. When working with a large amount of information, you can create multiple sheets to help organize your spreadsheet and make it easier to find information.

In this lesson, you'll learn how to create, rename, move, delete, and duplicate sheets.

Using multiple sheets

When you create a new Google spreadsheet, it has one sheet, which is named Sheet1 by default. In the sheets toolbar located at the bottom of the window, you will see a tab for each sheet you have. To organize your spreadsheet and make it easier to navigate, you can create, rename, delete, move, and duplicate sheets.

Watch the video below to learn how to create and manage multiple sheets.

To create a new sheet:

In our example, the sheets of our service log are organized by month. We'll create a new sheet in the log so data can be entered in the new month.

1. Click the Add Sheet command in the sheets toolbar.
   
2. A new sheet will appear in the sheets toolbar.
   

Alternatively, you can create an additional sheet by clicking Insert and selecting New sheet from the drop-down menu.

To rename a sheet:

1. Click the tab of the sheet you want to rename. Select Rename... from the menu that appears.
   
2. Type the desired name for the sheet.
   
3. Click anywhere outside of the tab or press Enter on your keyboard when you're finished, and the sheet will be renamed.
   

To switch to a different sheet:

1. Click the desired sheet tab in the sheets toolbar.
   
2. The selected sheet will appear.
   

If you want to limit collaborators from editing specific sheets of your spreadsheet, you can protect these sheets by clicking the desired sheet tab and selecting Protect sheet... from the menu that appears.

To move a sheet:

1. Click and drag the tab of the sheet you want to move.
   
2. Release the mouse to place the tab at the desired location.
   

To duplicate a sheet:

1. Click the tab of the sheet you want to duplicate, then select Duplicate from the menu that appears.
   
2. A duplicate of the sheet will appear in the sheets toolbar. It will be named as a copy of the original sheet, such as Copy of May. If you want, you can rename the sheet.
   

To copy a sheet to another spreadsheet in Google Drive, click the tab of the sheet you want to copy, then select Copy to... from the menu that appears. Select the spreadsheet where you want to place the copy from the list that appears. A duplicate of the sheet will appear in the other spreadsheet.

In Excel, you can select all sheets in a workbook and apply changes to all of them at once. If you select every sheet and change the value in one cell on one sheet, the new value is automatically entered in all selected sheets. For example, say you have a workbook with six sheets.

To select all sheets, right-click on any sheet’s tab (here, Sheet1), and choose Select All Sheets.

When sheets are selected, their color is changed to white, while unselected sheets have a gray background color.

Change Values in Selected Sheets

Now, to change the value of cell C36 in all sheets to 10, change the cell in any sheet in the workbook. Here, the value changed in Sheet1.

Now, switching to any tab (e.g., Sheet3) shows that the value of C36 is set to 10 in all worksheets.

Unselect All Sheets

To deselect all sheets, click on any of the selected tabs, and choose Ungroup Sheets.

Only the tab you right-clicked (here, Sheet1) is now selected.

Select Multiple Sheets at Once

You can also select multiple sheets at once without selecting them all. Use the CTRL button on the keyboard for the selection. Press and hold CTRL, then click on each tab (sheet name) you want to select.

To select consecutive sheets (e.g., Sheet2, Sheet3, Sheet4, and Sheet5), you could also use the SHIFT button. Select the first tab (here, Sheet2), press and hold SHIFT, and click on the last tab you want to select (here, Sheet5).

Now worksheets Sheet2 through Sheet5 are selected.

Note: To select worksheets without having to click each one, you can by tab name, index number, or VBA code name.

Select Multiple Sheets in Google Sheets

Google Sheets doesn’t have the Select All Sheets option, but you can use CTRL or SHIFT to select multiple or all sheets.

How do I copy formatting to all sheets in Google Sheets?

How do I make Google Sheets the same format?

How do I format all cells the same size in Google Sheets?