How to hide and unhide sheet tabs in Google Sheets

Configurare noua (How To)

Situatie

When you have a workbook with many sheets, it can feel tedious to scroll between them. In Google Sheets, you can hide your sheet tabs to see only those you need.

Solutie

To hide just one sheet, either right-click the tab or click the arrow in the tab to the right of the sheet name. Then, pick Hide Sheet.

The first time you hide a sheet tab after opening your workbook, you’ll see a brief confirmation message in the bottom right corner of Google Sheets.

Hide Multiple Sheets at Once:

Select the sheet tabs you want to hide. When you have multiple sheet tabs selected, they appear white while non-selected tabs remain gray. Right-click or use the tab arrow for one of the tabs in the group and pick Hide Sheets.

Unhide Sheets
Whether you hide one or more sheets, you unhide them the same way. Go to the View tab and you’ll see an option for Hidden Sheets along with the number of sheets hidden.

When you unhide a sheet, you’ll see it appear in the same spot in the tab row as before you hid it.

Tip solutie

Permanent

Voteaza

(6 din 11 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?