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 |
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 |
All times are GMT +1. The time now is 09:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com