Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 Heading for 2 columns
Is it possible to have 1 heading for 2 columns?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 Heading for 2 columns
Sun, 11 Nov 2007 18:30:00 -0800 from Beth
: Is it possible to have 1 heading for 2 columns? Yes. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 Heading for 2 columns
Sun, 11 Nov 2007 21:35:01 -0500 from Stan Brown
: Sun, 11 Nov 2007 18:30:00 -0800 from Beth : Is it possible to have 1 heading for 2 columns? 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 Heading for 2 columns
How do I do it? Or can you tell me where can I find out how?
Thank you, Beth "Stan Brown" wrote: Sun, 11 Nov 2007 21:35:01 -0500 from Stan Brown : Sun, 11 Nov 2007 18:30:00 -0800 from Beth : Is it possible to have 1 heading for 2 columns? 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 Heading for 2 columns
Just carefully follow Stan instructions and is done.
-- Can''''t hear the Rain ? Then listen to it. "Beth" wrote: How do I do it? Or can you tell me where can I find out how? Thank you, Beth "Stan Brown" wrote: Sun, 11 Nov 2007 21:35:01 -0500 from Stan Brown : Sun, 11 Nov 2007 18:30:00 -0800 from Beth : Is it possible to have 1 heading for 2 columns? 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 Heading for 2 columns
Many experts on this group would recommend avoiding merged cells like the
plague. May be safer to use Format/ Cells/ Alignment/ Centre Across Selection. -- David Biddulph "Stan Brown" wrote in message t... Sun, 11 Nov 2007 21:35:01 -0500 from Stan Brown : Sun, 11 Nov 2007 18:30:00 -0800 from Beth : Is it possible to have 1 heading for 2 columns? 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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 Heading for 2 columns
Sun, 11 Nov 2007 18:45:00 -0800 from Beth
: "Stan Brown" wrote: Sun, 11 Nov 2007 21:35:01 -0500 from Stan Brown : Sun, 11 Nov 2007 18:30:00 -0800 from Beth : Is it possible to have 1 heading for 2 columns? 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. 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 Heading for 2 columns
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? -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 Heading for 2 columns
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 On Mon, 12 Nov 2007 23:11:08 -0500, Stan Brown wrote: 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? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
1 Heading for 2 columns
Mon, 12 Nov 2007 21:05:19 -0800 from <Gord Dibben
<gorddibbATshawDOTca: On Mon, 12 Nov 2007 23:11:08 -0500, Stan Brown wrote: I wouldn't call myself an expert -- high intermediate at best. Can you enlighten me, please? What's wrong with merged cells? 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ "If there's one thing I know, it's men. I ought to: it's been my life work." -- Marie Dressler, in /Dinner at Eight/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 columns under one heading | Excel Discussion (Misc queries) | |||
How do i change the heading of excel columns to alphabetical | Excel Discussion (Misc queries) | |||
How do I put one heading over 3 narrow columns? | New Users to Excel | |||
Pivot Table, merge columns into one row heading? | Excel Discussion (Misc queries) | |||
Adding Columns/Heading | Excel Discussion (Misc queries) |