Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 06-26-2009, 02:55 PM
KroogerFx KroogerFx is offline
Registered User
 
Join Date: 26 Jun 2009
Location: Canada
MS Office Version:Excel 2003
Posts: 20
KroogerFx is becoming part of the community
Question How to make a title bar above several columns?

Please Register to Remove these Ads

Pretty simple question but I can't figure it out.
I just want a value field in a single row to span over 2 or more columns to use it as a title.

For example A1 and B1 is a single box that says Age/# of students
The rest of A would be age and the rest of B would be the number of students in that age group.

Thank You.

Last edited by KroogerFx; 06-26-2009 at 03:17 PM.
Reply With Quote
  #2  
Old 06-26-2009, 03:12 PM
protonLeah protonLeah is online now
Valued Forum Contributor
 
Join Date: 02 Mar 2006
Location: Los Angeles, Ca
MS Office Version:MSO2000+2007
Posts: 1,192
protonLeah is very confident of their ability protonLeah is very confident of their ability protonLeah is very confident of their ability
Re: How to make a title bar above several columns?

Two options. Type the title in A1, Select both A1 and B1, choose Format> Cells>Alignment. Then either:
1. Horizontal - Center across selection, or
2. Text control - merge cells
__________________
Ben Van Johnson
Reply With Quote
  #3  
Old 06-26-2009, 03:14 PM
KroogerFx KroogerFx is offline
Registered User
 
Join Date: 26 Jun 2009
Location: Canada
MS Office Version:Excel 2003
Posts: 20
KroogerFx is becoming part of the community
Re: How to make a title bar above several columns?

Exactly what I was looking for Thank you very much
Reply With Quote
  #4  
Old 06-26-2009, 03:20 PM
NV32 NV32 is offline
Registered User
 
Join Date: 26 Jun 2009
Location: Tampa
MS Office Version:Excel 2003
Posts: 2
NV32 is becoming part of the community
Help with vlookup, if ....

I need help w excel.
how i can combined several columns in other sheet if the person meet the criteria.

exampe (each number is separate column) first sheet
1. Maria Rodriguez
2. Start date
3. term date
4. 90 days


second sheet
i want pull with a formula all the employees that have been terminate over 90 days and i want to pull their name, start date, term date and let me know if meet the require 90 days only
like: Maria Rodriguez - start date - term date - 90 days (all in one row)
Reply With Quote
  #5  
Old 06-26-2009, 03:54 PM
protonLeah protonLeah is online now
Valued Forum Contributor
 
Join Date: 02 Mar 2006
Location: Los Angeles, Ca
MS Office Version:MSO2000+2007
Posts: 1,192
protonLeah is very confident of their ability protonLeah is very confident of their ability protonLeah is very confident of their ability
Re: How to make a title bar above several columns?

Do not hijack: Start your own thread!
__________________
Ben Van Johnson
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Forum Jump