Sunday, April 15, 2018

Unhide the first column or row in a worksheet

Unhide the first column or row in a worksheet

If you don't see the first column (column A) or row (row 1) in your worksheet, it might be hidden. Here's how to unhide it. In this picture column A and row 1 are hidden.

Hidden first column and row

To unhide column A, right-click the column B header or label and pick Unhide Columns.

Unhide option

To unhide row 1, right-click the row 2 header or label and pick Unhide Rows.

Tip: If you don't see Unhide Columns or Unhide Rows, make sure you're right-clicking inside the column or row label.

For more information about unhiding the other rows or columns, see Unhide (show) columns or rows.

No comments:

Post a Comment