Quick Answer: How Do You Unhide Multiple Rows In Excel 2013?

Why unhide is not working?

There are certain situations when you can’t “unhide” columns on the left and/or rows at the top and it is not a sheet protection issue.

It is also not an unhiding issue.

It is caused by Freeze Panes.

If you have scrolled down the sheet and then set your Freeze Panes it can stop you seeing the rows at the top..

How do I find hidden rows in Excel?

The approach is to first select all visible cells in the worksheet, which also will reveal hidden rows and columns….Locate hidden cellsPress F5 > Special.Press Ctrl+G > Special.Or on the Home tab, in the Editing group, click Find & Select>Go To Special.

How do I unhide multiple rows in Excel 2016?

Excel 2016: Unhide Rows or ColumnsSelect 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.

Can not unhide rows in Excel?

Can’t unhide rows A!:A3To select all cells on a worksheet, do one of the following: Click the Select All button. Press CTRL+A. … On the Home tab, in the Cells group, click Format.Do one of the following: Under Visibility, point to Hide & Unhide, and then click Unhide Rows or Unhide Columns.

How do I unhide rows at the top in Excel?

Unhide the first column or row in a worksheetTo select the first hidden row or column on the worksheet, do one of the following: In the Name Box next to the formula bar, type A1, and then press ENTER. … On the Home tab, in the Cells group, click Format.Do one of the following: Under Visibility, click Hide & Unhide, and then click Unhide Rows or Unhide Columns.

What is the shortcut to unhide columns in Excel?

Keyboard Shortcuts Alternatively, you can select a row or rows, and then press Ctrl-9. To unhide rows, press Ctrl-Shift-9. For columns, use Ctrl-0 (that’s a zero) or Ctrl-Shift-0, respectively.

What are hidden rows in Excel?

Just select the cell or cells, then go to Home, and in Cells group, click Format. Then under Visibility, point to Hide\Unhide, and then click Hide Rows or Hide Columns. This will hide the Rows or Columns of the selected cell or cells.

Why are rows missing in Excel?

Filtering will hide rows that remain hidden when choosing Unhide Rows, because the filter is still applied. To turn off filtering, select the Data menu, then select Filter, and see if either autofilter or advanced filter has a check-mark by it. If so, un-check it, and your rows should return.

How do I unhide rows in sheets?

How to Unhide Rows in Google Sheets (for larger datasets)Select all the row numbers and columns letters by clicking on the grey block on the top left of your spreadsheet.Next, right-click on your selection.If you have any rows hidden in the sheet, you should see a menu option that says “Unhide Rows”.

How do you unhide multiple rows in Excel?

How to unhide all rows in ExcelTo unhide all hidden rows in Excel, navigate to the “Home” tab.Click “Format,” which is located towards the right hand side of the toolbar.Navigate to the “Visibility” section. … Hover over “Hide & Unhide.”Select “Unhide Rows” from the list.

How do I unhide multiple columns in Excel 2016?

If you have an Excel table where multiple columns are hidden and want to show only some of them, follow the steps below.Select the columns to the left and right of the column you want to unhide. … Go to the Home tab > Cells group, and click Format > Hide & Unhide > Unhide columns.