Excel Table with Headers and Sub-headers, so Subheaders can be the same

Question

I would like to format data as a table that has headers and sub-headers.

For example, I have many header sections (like Baseline Costs and Actual Costs) that all have the same sub-headers that are Q1FY14, Q2FY14, and so on. I would like to make a table that uses the top header, so it knows the two Q1FY14's are different from each other.

I'm hoping then, it would refer to the parts as (in pivots and whatnot) as "Actual Costs- Q1FY14" and "Baseline Costs- Q1FY14".

The only option that I know of is formatting only the sub-header rows and data as a table, in which case it changes the title to "Q1FY142", "Q1FY143", etc.

Thanks!

Answer 1

Hi,

First and Foremost, please avoid giving more than 1 heading per column - you will face problem when creating Pivot Tables and Graphs.  Give headings as Baseline Costs - Q1FY14 and so on.

Furthermore, as you have aptly observed, a Table should have all distinctive headings.