UnHide Columns in Excel 2002

[lisab]

In Office XP in Excel I can not select two columns it automatically expands
the selection to include the Merged Row above it which includes all the
columns below - not just the two I selected. When I select just two cells
the right click does not include the option to "Unhide" or "Hide". I have
to go to the format menu, select column and select "Unhide" or "Hide".

Is there a way to select columns without including the merged rows within
the spreadsheet? Is there a shortcut to "Hide" or "UnHide" with a right
click or keyboard shortcut like in Office 2000?

[RWN]

Not sure if this is what you're after but, have you tried "Edit->GoTo->Special->Visible
Cells Only" after you've made your selection?

I should note that this is in xl2k and *assume* it's in XP.

--
Regards;
Rob
------------------------------------------------------------------------
"lisab" <[email protected]> wrote in message
news:[email protected]...
>
> In Office XP in Excel I can not select two columns it automatically
> expands
> the selection to include the Merged Row above it which includes all the
>
> columns below - not just the two I selected. When I select just two
> cells
> the right click does not include the option to "Unhide" or "Hide". I
> have
> to go to the format menu, select column and select "Unhide" or "Hide".
>
> Is there a way to select columns without including the merged rows
> within
> the spreadsheet? Is there a shortcut to "Hide" or "UnHide" with a
> right
> click or keyboard shortcut like in Office 2000?
>
>
> --
> lisab
> ------------------------------------------------------------------------
> lisab's Profile: http://www.excelforum.com/member.php...o&userid=28007
> View this thread: http://www.excelforum.com/showthread...hreadid=475120
>

[Lisa Beach]

Not really, in the upgrade to XP from 2000 there are lots of things that are
different and I am looking for a "shortcut" to hide/unhide columns. In 2000
if you select the entire column and right click you have the option to
hide/unhide. In XP if you select the entire column it automatically expands
the selection to all columns if there is a merged cell anywhere in the
workbook, so you can't just hide/unhide the specific column you selected.
The only way I can find to do it is to select a cell in the column, go to
the format menu, select column and then select hide/unhide - the right click
does not give the option to hide/unhide when you just select a cell. I
assume that there still is a shortcut or trick to do this, but I can't find
it anywhere.


"RWN" <[email protected]> wrote in message
news:[email protected]...
Not sure if this is what you're after but, have you tried
"Edit->GoTo->Special->Visible
Cells Only" after you've made your selection?

I should note that this is in xl2k and *assume* it's in XP.

--
Regards;
Rob
------------------------------------------------------------------------
"lisab" <[email protected]> wrote in
message
news:[email protected]...
>
> In Office XP in Excel I can not select two columns it automatically
> expands
> the selection to include the Merged Row above it which includes all the
>
> columns below - not just the two I selected. When I select just two
> cells
> the right click does not include the option to "Unhide" or "Hide". I
> have
> to go to the format menu, select column and select "Unhide" or "Hide".
>
> Is there a way to select columns without including the merged rows
> within
> the spreadsheet? Is there a shortcut to "Hide" or "UnHide" with a
> right
> click or keyboard shortcut like in Office 2000?
>
>
> --
> lisab
> ------------------------------------------------------------------------
> lisab's Profile:
> http://www.excelforum.com/member.php...o&userid=28007
> View this thread: http://www.excelforum.com/showthread...hreadid=475120
>