UnHide Columns in Excel 2002

L

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?
 
R

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.
 
L

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.


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top