Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Excel Upgrade - Office XP
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Upgrade - Office XP | Excel Discussion (Misc queries) | |||
Forcing Excel to Load Below Office Toolbar | Excel Discussion (Misc queries) | |||
seeking way to expire excel documents after certain date in Office | Excel Discussion (Misc queries) | |||
Why can I not open an Excel Compound file with Office Excel xp? | Excel Discussion (Misc queries) | |||
Reinstall Excel 2002 after removing it during upgrade to Office 20 | Excel Discussion (Misc queries) |