Formatting and Grouping Columns w/ Merge Cells

L

Lisa Beach

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
 

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

Similar Threads

Excel Question - Office XP Upgrade 0
Open my default template when right click, select New MS Word doc within a folder 0
UnHide Columns in Excel 2002 2
Formatting and Grouping Columns 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Selecting & Formatting Columns w/ Merged Cells 2
Shortcuts in OneDrive 0
Two columns : Continuous two columns vs Parallel two Column 1

Top