If you find any post useful then, please do share with others. Thanks!

Popular Posts


Email me

Need help and that also free? I like to learn this way, in case of any question or for a small task, please feel free to email me with details and example data, if required.

Tuesday, September 9, 2014

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.

No comments:

Post a Comment