- Select the columns or rows that are before and after the one you would like to unhide.
- Select the “Home” tab.
- In the “Cells” area, select “Format” > “Hide & Unhide” > “Unhide Columns” or “Unhide Rows” as desired.
- The column or row should now be unhidden.
.
Also know, how do you show hidden rows in Excel?
Select the entire sheet by clicking on the arrow in the upper left corner, then go to Home, and in the cells group, click "Format." Then under "Visibility," point to "Hide/Unhide," and click "Unhide Rows" or "Unhide Columns." This will hide the rows or columns of the selected cell or cells.
One may also ask, how do I unhide rows at the top of an Excel spreadsheet? To unhide the top rows of a worksheet when they are hidden, follow these steps:
- Press F5. Excel displays the Go To dialog box.
- In the Reference field at the bottom of the dialog box, enter the number of the row range that you want to unhide.
- Click on OK.
- Choose Row from the Format menu, then choose Unhide.
how do I unhide column A in Excel 2016?
Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide & Unhide > Unhide Columns. Now column A should be unhidden in your Excel spreadsheet.
Why are rows missing in Excel?
If you notice that several rows are missing, you can unhide all of the rows by doing the following: Hold down Ctrl (Windows) or ? Command (Mac) while clicking the row number above the hidden rows and the row number below the hidden rows. Right-click one of the selected row numbers.
How do I automatically hide rows in Excel?
- Select the row or column you want to hide. For instance, select row 5 to hide the April data.
- Click the Data tab. In Excel 2003, choose Group and Outline from the Data menu.
- Click Group in the Outline group and Excel will display an outline bracket to the left of row 5.
- To hide row 5, click the minus sign.
How do I unhide rows?
