This is probably a silly question, but I can't figure it out.

In Office 2000 in Excel when you select two columns and right click it
included the option to "Unhide" or "Hide".

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?

Thank you in advance for your reply's.

Lisa

"Lisa Beach" wrote:

This is probably a silly question, but I can't figure it out.

In Office 2000 in Excel when you select two columns and right click it
included the option to "Unhide" or "Hide".

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?

Thank you in advance for your reply's.

Lisa

No Message was sent.


"JR" wrote in message
...


"Lisa Beach" wrote:

This is probably a silly question, but I can't figure it out.

In Office 2000 in Excel when you select two columns and right click it
included the option to "Unhide" or "Hide".

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?

Thank you in advance for your reply's.

Lisa