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