![how to unhide columns in excel how to unhide columns in excel](https://excelnotes.com/wp-content/uploads/2020/02/excelunhidemultiplerows002large-1024x640.jpg)
How to unhide specific rows in Excelĭepending on which rows you want to unhide, select them as described below, and then apply one of the unhide options discussed above. To unhide all rows and columns, select the whole sheet as explained above, and then press Ctrl + Shift + 9 to show hidden rows and Ctrl + Shift + 0 to show hidden columns. On the Home tab, click Format > Unhide Rows (the traditional way).Select Unhide from the right-click menu (the easiest way that does not require remembering anything).Press Ctrl + Shift + 9 (the fastest way).Once the entire sheet is selected, you can unhide all rows by doing one of the following: But if the cursor is in one of contiguous cells with data, only that group of cells is selected to select all cells, press Ctrl+A one more time. If the cursor is in an empty cell, the whole worksheet is selected. Please note that in Microsoft Excel, this shortcut behaves differently in different situations. Press the Select All shortcut: Ctrl + A.Click the Select All button (a little triangle at the upper left corner of a sheet, in the intersection of the row and column headings):.In order to unhide all rows on a sheet, you need to select all rows. Simply hover your mouse over the hidden row headings, and when the mouse pointer turns into a split two-headed arrow, double click. The beauty of this method is that you don't need to select anything. In many situations, the fastest way to unhide rows in Excel is to double click them. Pressing this key combination (3 keys simultaneously) displays any hidden rows that intersect the selection. Here is the Excel Unhide Rows shortcut: Ctrl + Shift + 9 This method works beautifully for unhiding a single hidden row as well as multiple rows.įor example, to show all hidden rows between rows 1 and 8, select this group of rows like shown in the screenshot below, right-click, and click Unhide: You select a group of rows including the row above and below the row(s) you want to unhide, right-click the selection, and choose Unhide in the pop-up menu. On the Home tab, in the Cells group, click the Format button, point to Hide & Unhide under Visibility, and then click Unhide Rows. What makes the difference is the area you select to instruct Excel to unhide all hidden rows, only specific rows, or the first row in a sheet. Which one to use is a matter of your personal preference. If you'd rather not take your hands off the keyboard, you can quickly hide the selected row(s) by pressing this shortcut: Ctrl + 9 How to unhide rows in ExcelĪs with hiding rows, Microsoft Excel provides a few different ways to unhide them. In case you don't want to bother remembering the location of the Hide command on the ribbon, you can access it from the context menu: right click the selected rows, and then click Hide.
![how to unhide columns in excel how to unhide columns in excel](https://www.knowledgewave.com/hs-fs/hubfs/hideexcelrows1.png)
Under Visibility, point to Hide & Unhide, and then select Hide Rows.Īlternatively, you can click Home tab > Format > Row Height... and type 0 in the Row Height box.Įither way, the selected rows will be hidden from view straight away.Go to the Home tab > Cells group, and click the Format button.If you enjoy working with the ribbon, you can hide rows in this way: With the rows selected, proceed with one of the following options. To select non-contiguous rows, click the heading of the first row and hold down the Ctrl key while clicking the headings of other rows that you want to select.Or select the first row and hold down the Shift key while selecting the last row.
![how to unhide columns in excel how to unhide columns in excel](https://www.excelforum.com/attachments/tips-and-tutorials/657342d1578697000-excel-hide-unhide-columns-with-userform-column-hide-unhide.jpg)