LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 2 columns under one heading

I agree with this way to fix the problem; i have looked for a long time for
an icon I could put in my toolbar to save the multiple steps to make it work.
Does anyone know of such an icon?

"JE McGimpsey" wrote:

One way:

Put "Burger" in the heading cell of the left-hand column. Select that
cell and the one to the right. Choose Format/Cells/Alignment, and choose
Center across Selection from the Horizontal: dropdown.

You *could* also merge the two cells and center the text, but merged
cells are the devil's invention, and should never, ever, be used. Not
even once...

In article . com,
wrote:

I need to put two columns under one heading in Excel. Is there any
way this can be done? For example, let's say I need the heading
Burger, and underneath that heading I need one column reading
cheeseburger and the other hamburger, both under the same heading.
Does that make sense? Can this be done? Thank you for your help.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i change the heading of excel columns to alphabetical ThePubLounger Excel Discussion (Misc queries) 4 July 16th 09 02:57 AM
How do I put one heading over 3 narrow columns? Janice New Users to Excel 2 May 29th 07 11:58 PM
Pivot Table, merge columns into one row heading? [email protected] Excel Discussion (Misc queries) 1 April 19th 07 03:44 AM
Adding Columns/Heading debir Excel Discussion (Misc queries) 0 February 24th 06 01:29 PM
In a table produce an value by column heading and row heading naflan Excel Worksheet Functions 1 December 27th 05 05:18 PM


All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"