[rank_math_breadcrumb]
logo-v-light

Our Service

10 Shortcut Keys for Hiding in Excel

1. Ctrl+0 � Hide the selected rows

2. Ctrl+9 � Hide the selected columns

3. Ctrl+Shift+⌘+9 � Hide the selected sheets

4. Ctrl+6 � Hide the selected cells

5. Ctrl+8 � Hide the selected charts

6. Ctrl+7 � Hide the selected objects

7. Ctrl+Shift+⌘+7 � Hide the selected PivotTables

8. Ctrl+Shift+⌘+8 � Hide the selected Slicers

9. Ctrl+Shift+⌘+6 � Hide the selected Sparklines

10. Ctrl+Shift+⌘+5 � Hide the selected Timelines

Bonus tip: You can also use the Ctrl+⌘+9 shortcut to quickly hide all the rows in your worksheet, or the Ctrl+⌘+0 shortcut to hide all the columns.

If you want to quickly hide all the sheets in your workbook, you can use the Ctrl+Shift+⌘+A shortcut.

Remember, you can always use the Unhide command to bring back any hidden rows, columns, sheets, or objects.

Excel is a powerful tool that can help you manage and analyze data with ease. However, with so many features and functions, it can be overwhelming to navigate through the program. One of the most useful features in Excel is the ability to hide and unhide rows, columns, and worksheets. In this article, we will explore 10 shortcut keys for hiding in Excel.

Shortcut Keys for Hiding Rows and Columns

1. Ctrl + 9

This shortcut key allows you to hide the selected rows in Excel. Simply select the rows you want to hide and press Ctrl + 9. To unhide the rows, press Ctrl + Shift + 9.

2. Ctrl + 0

This shortcut key allows you to hide the selected columns in Excel. Simply select the columns you want to hide and press Ctrl + 0. To unhide the columns, press Ctrl + Shift + 0.

3. Alt + H + O + R

This shortcut key allows you to hide the selected rows in Excel. Simply select the rows you want to hide and press Alt + H + O + R. To unhide the rows, press Alt + H + O + U.

4. Alt + H + O + C

This shortcut key allows you to hide the selected columns in Excel. Simply select the columns you want to hide and press Alt + H + O + C. To unhide the columns, press Alt + H + O + U.

Shortcut Keys for Hiding Worksheets

5. Ctrl + Shift + 9

This shortcut key allows you to hide the selected worksheet in Excel. Simply select the worksheet you want to hide and press Ctrl + Shift + 9. To unhide the worksheet, right-click on any worksheet tab and select Unhide. Then, select the worksheet you want to unhide and click OK.

6. Ctrl + Page Up

This shortcut key allows you to switch to the previous worksheet in Excel. If the worksheet you want to hide is not the active worksheet, simply press Ctrl + Page Up to switch to the worksheet. Then, press Ctrl + Shift + 9 to hide the worksheet.

7. Ctrl + Page Down

This shortcut key allows you to switch to the next worksheet in Excel. If the worksheet you want to hide is not the active worksheet, simply press Ctrl + Page Down to switch to the worksheet. Then, press Ctrl + Shift + 9 to hide the worksheet.

8. Alt + H + O + H

This shortcut key allows you to hide the selected worksheet in Excel. Simply select the worksheet you want to hide and press Alt + H + O + H. To unhide the worksheet, right-click on any worksheet tab and select Unhide. Then, select the worksheet you want to unhide and click OK.

Shortcut Keys for Hiding Multiple Rows, Columns, and Worksheets

9. Shift + Spacebar

This shortcut key allows you to select the entire row in Excel. Simply click on the row number or press Shift + Spacebar to select the entire row. Then, use any of the shortcut keys mentioned above to hide the selected rows.

10. Ctrl + Spacebar

This shortcut key allows you to select the entire column in Excel. Simply click on the column letter or press Ctrl + Spacebar to select the entire column. Then, use any of the shortcut keys mentioned above to hide the selected columns.

By using these shortcut keys, you can save time and navigate through Excel with ease. Whether you need to hide rows, columns, or worksheets, these shortcut keys will help you get the job done quickly and efficiently.

Related

Did you find this article useful?

Share it with your friends or colleagues

About Aepoch Advisors

We are a boutique accounting and consulting firm servicing international businesses operating in China. We offers book keeping and business advisory service. We also help our clients select and implement SAAS business applications
 
Cloud technology significantly reduces cost foreign companies traditionally spent on tax compliance and ERP systems. Our cloud professionals can help with streamlining your management and controling structure, as well as advising you on how to reduce risks and maximize profits with software purposely built for Chinese business. Contact us today to learn more about our services.