Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-14-2009, 06:33 PM
RobotChicken RobotChicken is offline Mac OS X Office 2007
Novice
 
Join Date: Dec 2009
Posts: 2
RobotChicken is on a distinguished road
Question multiple colums under a single column



How can I do that in Excel? There are columns beneath columns. Or is there a better way to accomplish this?



Last edited by RobotChicken; 12-14-2009 at 07:06 PM. Reason: added last question
Reply With Quote
  #2  
Old 12-15-2009, 09:49 AM
CGM3 CGM3 is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Oct 2009
Posts: 39
CGM3 is on a distinguished road
Default

I'd suggest using the Merge Cells format. In the example you show, select the two cells that comprise the IN PLACE header, right click, choose Format Cells, on the Aligment tab click the Merge Cells check box. You'll probably want to center the text as well (same tab, at the top).
Reply With Quote
  #3  
Old 12-15-2009, 12:16 PM
RobotChicken RobotChicken is offline Mac OS X Office 2007
Novice
 
Join Date: Dec 2009
Posts: 2
RobotChicken is on a distinguished road
Default

Thank you.
Reply With Quote
  #4  
Old 01-06-2010, 09:17 AM
mcjohn mcjohn is offline Windows Vista Office 2007
Novice
 
Join Date: Jan 2010
Posts: 15
mcjohn is on a distinguished road
Default

I use this feature frequently and although not sure about 2003, in 2007 under home tab and alignment section there is a merge and center button.
Reply With Quote
Reply

Tags
err, frustrated, m$

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
autocorrect double space to single space frankjake Word 8 09-21-2018 05:44 PM
Single Space on Enter? crackinthekraken Word 4 12-09-2009 11:01 AM
Hyperlink on a single chart element jerh PowerPoint 0 09-14-2009 10:31 AM
Mail Merge--different connections of Access in Single Word File. Goldenbird Mail Merge 3 06-12-2009 06:42 AM
Last Number in a Column paulrm906 Excel 1 12-05-2008 07:51 PM


All times are GMT -7. The time now is 10:09 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft