T
the_divine_blade
How do I combine two row headings while keeping the actual rows separate?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Trevor Shuttleworth
Look at Merge Cells
First, select the cells and then:
Format | Cells... | Alignment | under Text control, select Merge Cells
Regards
Trevor
First, select the cells and then:
Format | Cells... | Alignment | under Text control, select Merge Cells
Regards
Trevor
R
Ragdyer
Strongly suggest that since there is the intent to keep the 2 *columns* as
separate entities, implying individual calculations and/or data, "Center
Across Selection" is the *preferred* method, instead of "Merge Cells".
<Format> <Cells> <Alignment> tab,
Expand the "Horizontal" window, and select,
"CenterAcrossSelection", <OK>.
Merge Cells will create various problems when the individual columns are to
be "worked" on; (i.e ... try sorting them).
separate entities, implying individual calculations and/or data, "Center
Across Selection" is the *preferred* method, instead of "Merge Cells".
<Format> <Cells> <Alignment> tab,
Expand the "Horizontal" window, and select,
"CenterAcrossSelection", <OK>.
Merge Cells will create various problems when the individual columns are to
be "worked" on; (i.e ... try sorting them).
T
Trevor Shuttleworth
RD
I couldn't agree more with regard to the problems that Merge Cells can give
you. I guess it really depends on what the OP wants to do with the data in
the columns and how he would like the headings to be presented. "Centre
across" does what it says on the box ... which does limit the formatting
options. May be a matter of taste.
Anyway, two options now.
Regards
Trevor
I couldn't agree more with regard to the problems that Merge Cells can give
you. I guess it really depends on what the OP wants to do with the data in
the columns and how he would like the headings to be presented. "Centre
across" does what it says on the box ... which does limit the formatting
options. May be a matter of taste.
Anyway, two options now.
Regards
Trevor
D
David McRitchie
As an alternative to merging cells vertically:
If the cells are of two different rows in the same column
you might consider using just one row and when entering
data into the cell hitting the ALT+Enter to get a new line
within the cell. You can use CHAR(10) in a concatenation,
but you will then have to use format, cells, alignment, wrap
so that the wrap will take effect; otherwise, you will see
square bullet symbols for unprintable characters.
You can then format the row to be aligned at the top or
at the bottom of the cells.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
If the cells are of two different rows in the same column
you might consider using just one row and when entering
data into the cell hitting the ALT+Enter to get a new line
within the cell. You can use CHAR(10) in a concatenation,
but you will then have to use format, cells, alignment, wrap
so that the wrap will take effect; otherwise, you will see
square bullet symbols for unprintable characters.
You can then format the row to be aligned at the top or
at the bottom of the cells.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm