How to make a title bar above several columns?

**KroogerFx** · 06-26-2009, 03:55 PM

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.

**protonLeah** · 06-26-2009, 04:12 PM

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

**KroogerFx** · 06-26-2009, 04:14 PM

Exactly what I was looking for Thank you very much

**NV32** · 06-26-2009, 04:20 PM

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)