Excel Upgrade - Office XP

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

Hi Lisa,

Do the following:

1. Press Alt-F11 add a module and cut and paste text below.

Sub Macro_Hide()
Dim x As Integer
Dim y As Integer
x = UserForm1.TextBox1.Value
y = UserForm1.TextBox2.Value
Rows(x & ":" & y).Select
Selection.EntireRow.Hidden = True
End Sub

Sub Macro_Unhide()
Dim x As Integer
Dim y As Integer
x = UserForm1.TextBox1.Value
y = UserForm1.TextBox2.Value
Rows(x & ":" & y).Select
Selection.EntireRow.Hidden = False
End Sub

2. Insert Userform1.
3. Place 2 TextBox1 and TextBox2 and 2 CommanButtons 1&2.
4. Place the row (integer) that you want to hide and unhide on the textbox.

Hope this helps.

"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
>
>
>