| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
merging cells excel 2003
Hello,
I have a spreadsheet which has 3 headings each 3 columns wide. bcd - efg - ghi Now on the 2nd row each on of the 3 columns has been merged so you can write in the title, "Available for Monday" "Available Later" "Never Available". So far so good. But the columns below (about 100 of them) are not merged. |----------------|-----------------|----------------| |---|-----|------|----|-----|------|---|-----|------| |---|-----|------|----|-----|------|---|-----|------| |---|-----|------|----|-----|------|---|-----|------| .... .... |---|-----|------|----|-----|------|---|-----|------| looks a bit like that. I want to merge the cells 3 at a time left to right. But when I select the cells and hit the merge button on the toolbar, the cells are merged top to bottom as well as left to right ie I get 3 BIG cells 3 X 100. But I want |----------------|-----------------|----------------| |----------------|-----------------|----------------| |----------------|-----------------|----------------| |----------------|-----------------|----------------| .... ... |----------------|-----------------|----------------| How do I do that plz? TIA Tony |
|
#2
|
|||
|
|||
|
Tony,
This may be a better choice... Format | Cells | Alignment (tab) - Horizontal: (box) - Center Across Selection Regards, Jim Cone San Francisco, USA "tony" wrote in message m... Hello, I have a spreadsheet which has 3 headings each 3 columns wide. bcd - efg - ghi Now on the 2nd row each on of the 3 columns has been merged so you can write in the title, "Available for Monday" "Available Later" "Never Available". So far so good. But the columns below (about 100 of them) are not merged. |----------------|-----------------|----------------| |---|-----|------|----|-----|------|---|-----|------| |---|-----|------|----|-----|------|---|-----|------| |---|-----|------|----|-----|------|---|-----|------| ... ... |---|-----|------|----|-----|------|---|-----|------| looks a bit like that. I want to merge the cells 3 at a time left to right. But when I select the cells and hit the merge button on the toolbar, the cells are merged top to bottom as well as left to right ie I get 3 BIG cells 3 X 100. But I want |----------------|-----------------|----------------| |----------------|-----------------|----------------| |----------------|-----------------|----------------| |----------------|-----------------|----------------| ... .. |----------------|-----------------|----------------| How do I do that plz? TIA Tony |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 97 macros to Excel 2003 | Excel Worksheet Functions | |||
| CHR() function not working in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) | |||
| Excel 2003 - cells in formula? | Excel Discussion (Misc queries) | |||
| Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) | |||
Hybrid Mode
