Hide Rows and Columns in Excel: Shortcut & Other Techniques

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.


Download the Practice Workbook

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


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 Freeze Rows and Columns at the Same Time 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 key 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: [Fixed!] Missing Row Numbers and Column Letters in Excel (3 Solutions)


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

Read More: How to Add Rows and Columns in Excel (3 Easy Methods)


Similar Readings


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: Move Row/Column in Excel Without Replacing Existing Data (3 Best Ways)


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 Add Multiple Rows and Columns in Excel (Every Possible Way)


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.


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. And please visit our website Exceldemy to explore more.


Related Articles

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo