Formatting Heading Rows with AutoFormat

[Kris]

Hi,
I have a user who is trying to use AutoFormat but, when it is applied,
most of the rows are formatted with the heading style and the last few
rows are formatted with the alternate shading. How do you tell Excel
that the first three rows are the heading and the rest is the body of
the spreadsheet?

 

[Debra Dalgleish]

Excel seems to determine the heading cells by where the data type
changes, in one or more columns. Perhaps the user's table has numbers as
headings in some of the columns (e.g. Year), and numbers in those
columns. In the headings, type an apostrophe before the number, to enter
it as text -- '2004

Or, enter a dummy row of data below the headings, and hide that row. For
example, if the headings are all text, type a zero in each cell, then
autoformat the table, and hide the row of zeros.

Instead of three rows of headings, the user may be able to enter the
headings in one row, adding line breaks in the cell by typing Alt+Enter