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.
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.
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.
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 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.
Read More: How to Add Rows and Columns in Excel (3 Easy Methods)
- How to Switch Rows and Columns in Excel Chart (2 Methods)
- [Fixed!] Rows and Columns Are Both Numbers in Excel
- How to Transpose Column to Multiple Rows in Excel (6 Methods)
- Excel VBA: Set Range by Row and Column Number (3 Examples)
- How to Convert Multiple Rows to Columns in Excel (9 Ways)
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.
❶ 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.
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.
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.
Or you can select the adjacent two columns of the hidden columns. Then go to Home > Format > Hide & Unhide > Unhide Columns.
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.