View Single Post
  #1   Report Post  
tony
 
Posts: n/a
Default 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