G
Guest
Is it possible to have 1 heading for 2 columns?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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.
S
Stan Brown
Sun, 11 Nov 2007 18:30:00 -0800 from Beth
Yes.
Is it possible to have 1 heading for 2 columns?
Yes.
S
Stan Brown
Sun, 11 Nov 2007 21:35:01 -0500 from Stan Brown
Now that I've answered the question you asked, here's what you really
want to know: Highlight the two cells, right-click and select Format
Cells. On the Alignment tab, select Merge.
Sun, 11 Nov 2007 18:30:00 -0800 from Beth
Yes.
Now that I've answered the question you asked, here's what you really
want to know: Highlight the two cells, right-click and select Format
Cells. On the Alignment tab, select Merge.
G
Guest
How do I do it? Or can you tell me where can I find out how?
Thank you,
Beth
Thank you,
Beth
G
Guest
Just carefully follow Stan instructions and is done.
D
David Biddulph
Many experts on this group would recommend avoiding merged cells like the
plague. May be safer to use Format/ Cells/ Alignment/ Centre Across
Selection.
plague. May be safer to use Format/ Cells/ Alignment/ Centre Across
Selection.
S
Stan Brown
Sun, 11 Nov 2007 18:45:00 -0800 from Beth
You quoted my answer to your question. It's usually a good idea to
read an article before you post a follow-up query.
How do I do it? Or can you tell me where can I find out how?
You quoted my answer to your question. It's usually a good idea to
read an article before you post a follow-up query.
S
Stan Brown
Mon, 12 Nov 2007 08:11:22 -0000 from <"David Biddulph" <groups [at]
biddulph.org.uk>>:
I wouldn't call myself an expert -- high intermediate at best. Can
you enlighten me, please? What's wrong with merged cells?
biddulph.org.uk>>:
Many experts on this group would recommend avoiding merged cells like the
plague.
I wouldn't call myself an expert -- high intermediate at best. Can
you enlighten me, please? What's wrong with merged cells?
G
Gord Dibben
Merged cells cause no end of problems with sorting, copying, pasting, filtering
and a host of other functions, one of which is you can't use array formulas on a
range with merged cells.
To experiment, merge a few cells and try the above functions with a range that
has merged and unmerged cells.
Gord Dibben MS Excel MVP
and a host of other functions, one of which is you can't use array formulas on a
range with merged cells.
To experiment, merge a few cells and try the above functions with a range that
has merged and unmerged cells.
Gord Dibben MS Excel MVP
Mon, 12 Nov 2007 08:11:22 -0000 from <"David Biddulph" <groups [at]
biddulph.org.uk>>:Many experts on this group would recommend avoiding merged cells like the
plague.
I wouldn't call myself an expert -- high intermediate at best. Can
you enlighten me, please? What's wrong with merged cells?
S
Stan Brown
Mon, 12 Nov 2007 21:05:19 -0800 from <Gord Dibben
Thanks, Gord.
Merged cells cause no end of problems with sorting, copying,
pasting, filtering and a host of other functions, one of which is
you can't use array formulas on a range with merged cells.
To experiment, merge a few cells and try the above functions with a
range that has merged and unmerged cells.
Thanks, Gord.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.