LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Lisa Beach
 
Posts: n/a
Default Selecting & Formatting Columns w/ Merged Cells

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?

Thank you in advance for your reply's.

Lisa


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns Rob the Winer Excel Worksheet Functions 7 October 5th 05 03:41 AM
Sorting Area with Merged Cells prizm1 New Users to Excel 3 September 10th 05 11:49 PM
Clearing the Contents of Merged Cells prizm1 New Users to Excel 2 September 10th 05 04:42 AM
Formula to delete blank cells across multiple columns? SamFunMail Excel Worksheet Functions 2 September 1st 05 07:05 AM
Cells losing formatting BdgBill Excel Discussion (Misc queries) 1 November 26th 04 08:03 AM


All times are GMT +1. The time now is 07:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"