Adding Column Heading w/o Using a Row Number

[Guest]

I want to add headings to my columns starting with row 1, etc., but I need to
add column headings above row 1. I want my worksheet to be formatted so that
all column headings are on unnumbered rows with row 1 of the worksheet
appearing below the column headings. How do I do this?

 

[Bernard Liengme]

In a word (or 2): you can't

 

[David Biddulph]

.... but you can insert a new column A, and put your pseudo row numbers in
there. You can switch off the display of normal row & column headers
through Tools/ Options/ View ... (and use Freeze pains to show your
pseudo-headings, if you so wish).

 

[Guest]

I know how to add headings to my columns starting with row 1, etc., but I need to
add column headings above row 1. I want my worksheet to be formatted so that
all column headings are on unnumbered rows with row 1 of the worksheet
appearing below the column headings. How do I do this?