If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merging individual cells within a column - need help!
I need to merge individually selected cells within a
column. For example: column 1 Cell 1: 01 New Defects Cell 2: 02 New Enhancements Cell 3: 01 New defects Cell 4: 12 Deferred Cell 5: 01 New Defects Cell 6: Deferred You get the idea. I need to select cells 1,3, and 5, then merge the cells so that there is only one cell with 01 New Defects but that cell will stretch to cover all of the rows for each selected 01 New Defects. When I select the cells (with doc in Web view and paragraph markings turned on), Merge Cells is not available. The only time it is available is if I select the entire document then everything is put into one giant cell. I know this can be done as the doument I amd trying to update has had this done to it. But the person that did this is no longer available. I hope I have made this clear, Please help if possible, thanks, greg |
#2
|
|||
|
|||
Merging individual cells within a column - need help!
G'Day Greg,
On the face of it. what you are doing is NOT possible. However, if you first SORT the table so that all "01 New defects" cells are together (immediately vertically above/below each other), THEN you will be able to merge them! -- Regards, Pat Garard Australia ______________________________________ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with Merging Data Cells with Empty Cells | Te_Diddy | General Discussion | 3 | August 9th, 2004 10:33 AM |
Req: How to get all cells with data into one column | Adam | Running & Setting Up Queries | 2 | July 11th, 2004 06:27 AM |
Countif with 2 or more data ranges in same column | Doug | Worksheet Functions | 1 | July 4th, 2004 08:57 AM |