Hide Rows and Columns in Excel: Shortcut & Other Techniques

Get FREE Advanced Excel Exercises with Solutions!

When we have a very large datasheet, we want to hide some of the rows in Excel. To hide rows manually, may take some extra time from you. But using shortcuts for this purpose can really help save some of your time. In this article, you will learn a shortcut key to hide rows in Excel.


Shortcut to Hide Rows in Excel

You can use CTRL + 9 keys together to hide rows in Excel. This shortcut works both for hiding single as well as multiple rows in Excel.

Now, let’s see how can you use this shortcut key to hide a single row in Excel.

❶ At first select an entire row in Excel. You can select a single row by using one of the two following ways:

  • Left-click on the row number that you want to select.
  • Or, click on any cell to select. After that press SHIFT + Space This will select the entire row of that selected cell.

❷ After selecting the rows, press CTRL + 9 keys together.

This will instantly hide the selected row.

Shortcut to Hide Rows in Excel

When you are done with hiding the selected row, you will see the hidden row is replaced by two parallel lines.

To hide multiple rows in Excel,

❶ Select all the rows first. You can use SHIFT + Space to select the entire rows.

❷ Then press CTRL + 9 keys together.

Shortcut to Hide Rows in Excel for multiple rows

Read More: How to Hide Rows Based on Cell Value in Excel


Shortcut to Unhide Rows in Excel

We’ve two rows hidden in between cells 6 and 9. There are several ways available to unhide them. But you can use CTRL + SHIFT + 9 keys altogether to unhide them instantly. All you need to do is,

❶ First, select the two cells across the hidden cells.

❷ After that press CTRL + SHIFT + 9.

This will instantly unhide all the hidden rows in Excel.

Shortcut to Unhide Rows in Excel

Read More: Shortcut to Unhide Rows in Excel 


Shortcut to Hide Columns in Excel

To hide the columns in Excel,

❶ Select the column that you want to hide.

❷ Press the CTRL key and hold it. After that, press the 0 key.

This will hide the selected columns in Excel.

Shortcut to Hide Columns in Excel


Shortcut to Unhide Columns in Excel

To unhide columns in Excel using the keyboard shortcut keys,

❶ Select the adjacent column of the hidden columns.

❷ Then press CTRL + SHIFT + 0 keys together.

This will instantly unhide the hidden columns in Excel.

If this doesn’t work for you, then try ALT > O > C > U. This is an Excel 2003 shortcut key that still works for some cases.

Shortcut to Unhide Columns in Excel


Manually Hide Rows in Excel

If you want to hide rows in Excel manually then,

❶ Select the rows that you want to hide.

❷ Then right-click on them.

❸ From the pop-up menu, choose to Hide.

Manually Hide Rows in Excel

Alternatively,

❶ You can go to the Home tab by selecting the rows first.

❷ After that, from the Cells group, choose Format.

❸ From the drop-down list, click on Hide & Unhide.

❹ Then choose Hide Rows.

Read More: VBA to Hide Rows in Excel


Manually Unhide Rows in Excel

To unhide rows,

❶ Place your mouse cursor in between two rows where the hidden rows reside.

❷ Then right-click on them and choose Unhide from the pop-up list.

Or you can select the adjacent rows of the hidden rows. Then go to Home > Format > Hide & Unhide > Unhide Rows.

Manually Unhide Rows in Excel

Read More: How to Unhide Rows in Excel


Hide Columns Manually in Excel

To hide columns in Excel,

❶ Select the column or columns that you want to hide.

❷ Right-click on the selection area.

❸ Choose Hide from the pop-up menu.

Or you can go to Home > Format > Hide & Unhide > Hide Columns.

Hide Columns Manually in Excel


Unhide Columns Manually in Excel

To unhide columns manually in Excel,

❶ Place your mouse curse in between the parallel lines of the adjacent two columns.

❷ Right-click on it.

❸ Choose Unhide from the pop-up list.

Unhide Columns Manually in Excel

Or you can select the adjacent two columns of the hidden columns. Then go to  Home > Format > Hide & Unhide > Unhide Columns.


Download Practice Workbook

You can download the Excel file from the following link and practice along with it.


Conclusion

To sum up, we have demonstrated the usage of shortcut keys to hide rows in Excel. You are recommended to download the practice workbook attached along with this article and practice all the methods with that. And don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries ASAP.


Related Articles


<< Go Back to Hide Rows | Rows in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mrinmoy Roy
Mrinmoy Roy

Mrinmoy Roy, a dedicated professional with a BSc in Electronics and Communication Engineering from Khulna University of Engineering & Technology, Bangladesh, brings over two years of expertise to the ExcelDemy project. As a prolific contributor, he has authored around 180 articles, showcasing his deep knowledge and passion for Microsoft Excel, Data Analysis, and VBA. His unwavering commitment to continuous learning, combined with versatile skills, renders him well-suited for roles in data management and spreadsheet solutions. He has interest... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo