To unhide column A, right-click the column B header or label and select Unhide Column. To unhide row 1, right-click the row 2 header or label and select Unhide Row.Tip: If you don’t see Unhide Columns or Unhide Rows, make sure you are Right click inside Column or row labels.

Why can’t I unhide columns in Excel?

If you scroll to the right then set freeze panes then it prevents you from seeing the column on the left. If you scroll down the sheet, and then set Freeze Panes, it may prevent you from seeing the top row.

How to unhide column A in Excel?

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide and Unhide > Unhide Columns. Column A should now be unhidden in the Excel spreadsheet.

Why can’t I unhide a row?

Click the Sort and Filter button on the Home tab of the Ribbon, and then click Clear.Try the following: … On the Home tab, click Format icon selection to hide and unhide drop-down menu and select Unhide Rows. After that you should be able to unhide all rows in between.

How can I unhide rows that won’t be unhidden?

Unable to unhide row A!:A3

1. To select all cells on the worksheet, do one of the following: Click the Select All button. Press CTRL+A. …
2. On the Home tab, in the Cells group, click Format.
3. Do one of the following: Under Visibility, point to Hide and Unhide, and then click Unhide Rows or Unhide Columns.

How to unhide columns in Excel (including unhiding column A and unhiding row 1)

20 related questions found

How to force Excel to unhide rows?

How to Unhide All Rows in Excel

1. To unhide all hidden rows in Excel, navigate to the Home tab.
2. Click Format on the right side of the toolbar.
3. Navigate to the « Visibility » section. …
4. Hover over Hide and Unhide.
5. Select Unhide Rows from the list.

How to unhide all rows at once?

Ctrl + Shift + 9 Unhide all rows or Ctrl+Shift+0 (zero) to unhide all columns. If that doesn’t work, right-click the row or column identifier and select Unhide.

How to enable unhide in Excel?

In your Excel workbook, Right click on any sheet tab and select Unhide…from the context menu. In the Unhide box, select the hidden worksheets you want to show, and then click OK (or double-click the worksheet name). complete!

How to unhide column A in Excel 2007?

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide and Unhide > Unhide Columns. You should now be able to see column A in the Excel spreadsheet.

How to unhide A1?

Show hidden first column

1. Choose Go from the Edit menu, or press F5. Excel displays the Go To dialog box. …
2. In the Reference field at the bottom of the dialog, enter A1.
3. Click OK. Cell A1 is now selected, even though you can’t see it on the screen.
4. Choose Columns from the Format menu, and then choose Unhide.

How to unhide column A in Excel 2016?

To unhide the column, follow these steps:

1. Place the mouse pointer over the column letter A in the frame, and drag the pointer to the right to select columns A and C. …
2. Click the drop-down button attached to the Format button in the Cells group on the Home tab.
3. Click Hide and Unhide→Unhide Columns on the drop-down menu.

How to unhide column A in Excel 2010?

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide and Unhide > Unhide Columns. You should now be able to see column A in the Excel spreadsheet.

How to unhide a column in a worksheet?

To unhide on desktop or mobile, Just click or tap the little arrows on either side of the hidden column or row. If you are on the desktop, another way to unhide is to select the range of columns on either side of the hidden column, right-click, and select Unhide Columns.

How do you unhide cells?

The process looks a bit like this:

1. Select the columns to the left and right of the column you want to unhide.
2. Go to the Home tab and find the Cells group. Next, click the Format tab and find Hide and Unhide in the drop-down menu.
3. Select the Unhide Columns option and you should now see the hidden data.

How to unhide columns in Teams?

unhide column

1. Select the column adjacent to the hidden column.
2. Right-click the selected column and select Unhide.

How to unhide the first row in Excel 2007?

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide and Unhide > Unhide Rows. You should now see line 1.

How to unhide hidden columns in Excel 2007?

On the Home tab, click Format Cell group, then under Visibility, select Hide and Unhide, and then unhide the sheet. Alternatively, you can right-click any visible tab and select Unhide.

How to hide and unhide in Excel 2007?

exist Home Commands Tab, in the Cells group, click Format. From the Visibility section of the Format menu, choose Hide and Unhide » Unhide Columns. The column appears again.

What is the shortcut to unhide a column in Excel?

There are several dedicated keyboard shortcuts to hide and unhide rows and columns.

1. Ctrl+9 hides the line.
2. Ctrl+0 (zero) hides the column.
3. Ctrl+Shift+( Unhide lines.
4. Ctrl+Shift+) to unhide columns – if that doesn’t work for you, try Alt, O, C, U (old Excel 2003 shortcuts that still work).

Can’t unhide Excel worksheets?

All you have to do is right-click on any visible sheet, click Unhide, and select the sheet you want to view. Very hidden sheets are another story. If the workbook contains only very hidden sheets, you can’t even open the Unhide dialog, because the Unhide command will be disabled.

Is there a way to unhide all tabs in Excel?

Unhide multiple worksheets

1. Right-click the sheet tab at the bottom and select Unhide.
2. In the Unhide dialog box, – Ctrl (CMD on Mac) and click the sheet you want to display, or . – Press Shift + Up/Down Arrow keys to select multiple (or all) sheets, then press OK.

How to unhide hidden cells in Excel?

Right-click the selected column or row to hide and select Hide. (This method will not work if you enter column or row identifiers.) Click the Home tab, and in the Cells group, click Format > Hide and Unhide and select Hide Rows or Hide Columns.

How to unhide all rows in a worksheet?

Once you know there are hidden rows in your worksheet, here’s a quick way to unhide all hidden rows:

1. Select the row headers of all rows in the range.
2. Right-click and select the « Unhide Rows » option.
3. All hidden rows should now become visible at the same time.

How to unhide the top row in Excel 2016?

Select the Home tab from the toolbar at the top of the screen. Select Cells > Format > Hide and Unhide > Unhide Rows. Row 1 should now be visible in the spreadsheet.

Can you unhide multiple rows in Excel at once?

If you notice a few lines are missing, you can unhide all lines by doing the following: Hold down Ctrl (Windows) or the ⌘ command (Mac), and click the line number above the hidden line and the line number below the hidden line at the same time. Right-click on one of the selected line numbers. Click Unhide in the drop-down menu.