Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
You need to unmerge the cells.
HTH "Lisa Beach" wrote: 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 |
#3
|
|||
|
|||
In 2000 it never expanded the selection based on merged cells it only
selected the columns highlighted. If anyone else has a work around for this I would appreciate it. I have several spreadsheets where the first row or two are centered across columns for printing purposes and I only need to show the column for the current month, so I am constantly hiding and unhiding columns. Thank you again. Lisa "Ray A" wrote in message ... You need to unmerge the cells. HTH "Lisa Beach" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns | Excel Worksheet Functions | |||
Sorting Area with Merged Cells | New Users to Excel | |||
Clearing the Contents of Merged Cells | New Users to Excel | |||
Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
Cells losing formatting | Excel Discussion (Misc queries) |