T
Tony Dalton
Will MS make the unhide options in Excel clearer?
-------------------------------------------------
Excel Helpdesk tipsheet
=======================
Something for the Knowledge base.
Recently I was asked how to unhide some columns in an
Excel spreadsheet.
Normally this is easy -
Select the columns on either side of the hidden column(s),
click right mouse in the black selected area,
select the unhide command.
However this does not work with Column A.
You can try the Window, Unhide command - but this is
greyed out.
There are two ways of unhiding a hidden column A.
First select the whole spreadsheet
Use the Format, Columns command
then either:
select the Unhide command or
format columns width command, type 10, click ok.
The confusion arises because Excel uses the same words to
hide/unhide both columns and windows but only the Window,
Hide/Unhide command is readily visible in the command menu
structure.
Since this version of the unhide command is more obvious
it is easy for the user to be misled and try to use this
one rather than the format, columns command.
The format command refers to the column width while the
Window refers to the current Window. Both can be hidden
but are completely different commands.
The confusion is made a more likely because Microsoft have
not been consistent in designing the column-unhide and row-
unhide commands.
The rows can be unhidden using the right mouse unhide
command, even if the hidden rows are the topmost rows. So
you can use this procedure to unhide any hidden rows,
including row 1.
Select the whole worksheet
Click right mouse on the black selection area
select the unhide command
The hidden rows will appear.
-------------------------------------------------
Excel Helpdesk tipsheet
=======================
Something for the Knowledge base.
Recently I was asked how to unhide some columns in an
Excel spreadsheet.
Normally this is easy -
Select the columns on either side of the hidden column(s),
click right mouse in the black selected area,
select the unhide command.
However this does not work with Column A.
You can try the Window, Unhide command - but this is
greyed out.
There are two ways of unhiding a hidden column A.
First select the whole spreadsheet
Use the Format, Columns command
then either:
select the Unhide command or
format columns width command, type 10, click ok.
The confusion arises because Excel uses the same words to
hide/unhide both columns and windows but only the Window,
Hide/Unhide command is readily visible in the command menu
structure.
Since this version of the unhide command is more obvious
it is easy for the user to be misled and try to use this
one rather than the format, columns command.
The format command refers to the column width while the
Window refers to the current Window. Both can be hidden
but are completely different commands.
The confusion is made a more likely because Microsoft have
not been consistent in designing the column-unhide and row-
unhide commands.
The rows can be unhidden using the right mouse unhide
command, even if the hidden rows are the topmost rows. So
you can use this procedure to unhide any hidden rows,
including row 1.
Select the whole worksheet
Click right mouse on the black selection area
select the unhide command
The hidden rows will appear.