To add the macro to your Excel, perform these steps: If you are bored with routines, you can automate the process with this macro: If your Excel file contains a reasonable number of sheets, it's no big deal to hide them manually using one of the methods described above. In some situations, you may need to hide all worksheets except one.
#EXCEL KEYBOARD SHORTCUTS HIDE UNHIDE HOW TO#
How to hide all worksheets but active sheet with VBA If you capitalize the letter, then it will be CTRL + SHIFT + your key.įor example, you may choose to hide sheets with this shortcut: Ctrl + Shift + H If you type a lowercase letter, it will be CTRL + your key.
#EXCEL KEYBOARD SHORTCUTS HIDE UNHIDE CODE#
Go to the Developer tab > Code group, and click Macros.After that, carry out the following steps to assign the desired keyboard shortcut to the macro: You insert the macro in your Excel in the usual way (the detailed instructions can be found here). MsgBox Error, vbOKOnly, "Unable to Hide Worksheet" If you want to be able to hide sheets with a single keystroke, use the following simple macro to hide selected sheets, and then assign a key combination of your choosing to execute the macro.Ī = False Hide sheets with a custom keyboard shortcut Once you press Alt, Excel will show you which key activates which menu: The best thing is that you don't actually have to memorize these keys. Select the sheets to be hidden and press the following keys one by one, not all at once: Alt, H, O, U, S
How to hide Excel sheet with a key sequence Under Visibility, point to Hide & Unhide, and click Hide Sheet.Īlthough Microsoft Excel provides no keyboard shortcut for hiding sheets, one of the following workarounds can work a treat.On the Home tab, in the Cells group, click Format.If there is no unselected sheet, right-click any of the selected sheet tabs, and choose Ungroup Sheets from the context menu.Īnother way to hide worksheets in Excel is by clicking the Hide Sheet command on the ribbon. To ungroup the worksheets, click any unselected sheet. Selecting multiple worksheets groups them together the word appears after the file name in the title bar.Therefore, after you have selected all sheets, hold the Ctrl key and click one of the sheet tabs (any tab except the active one) to unselect that sheet. It is not possible to hide absolutely all sheets in a workbook, at least one sheet should remain in view.To select all sheets, right-click any sheet tab, and then click Select All Sheets.To select multiple non- contiguous sheets, hold down the Ctrl key while clicking the sheet tabs individually.To select multiple contiguous sheets, click the tab of the first sheet, hold down the Shift key, and click the tab of the last sheet.To select a single sheet, click its tab.Here's how you can quickly select multiple or all worksheets in Excel: Right-click the selection and choose Hide from the context menu.ĭone! The selected sheets are no longer in view.This tip explains how to select multiple sheets. Select one or more sheets you want to hide.The fastest way to hide sheets in Excel is this: How to hide sheets in Excel by right-clicking Hide all sheets except active one with VBA.The fastest way to hide sheets in Excel.
Fortunately, you can easily hide as many sheets as you like as long as at least one spreadsheet remains visible. But what if you don't want all of your worksheets to be there? Say, some sheets contain source data referenced by your formulas and you'd rather not show that data to other users. Normally, when you open Excel, you can see all sheet tabs at the bottom of your workbook. Learn how to quickly hide selected worksheets in Excel via the right-click menu and how to hide all sheets except active one with VBA.
0 kommentar(er)
