Unhide the very first column or row of a sheet

Unhide the very first column or row of a sheet

If the first row (Row1) or column (A Column) is hidden in the sheet then un-hiding it could be a bit tricky. The reason is that it’s hard to select that row or column. Though we can select the entire sheet and then unhide rows/columns but that will unhide all columns/rows that we might not want.

Below is an easy way mentioned to do this.

In the Name box which is next to formula bar, write A1 and then press enter button.

Now go to Home tab, in the cells group and Click on Format.

Now under Visibility, click Hide & unhide and then click on unhide rows or unhide columns.

This will unhide the column/row.