Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Unhide Show Columns Or Rows. Alt H O U L. You can quickly discern that a row or column is hidden by the missing header.
This will select all the cells in the worksheet. If you hide a column by mistake you can quickly get it back by pressing Undo. Right-click the header of the column you want to hide and choose Hide Column.
This will select all the cells in the worksheet.
Release the mouse with the pointer over the Select All cell the blank gray cell that intersects the header and row cells. You can quickly discern that a row or column is hidden by the missing header. Doing so will select everything to. But if you would rather not use your mouse you can use the Key Tips to access the same command on the.