How do I add header information to an Excel file? In other words,.
 

how do I name the columns?

Alvin

You cannot rename the columns as such, but if you put you titles in row 1
for example, you can always show these on screen by clicking on B2" and
invoking WindowFreeze Panes.

You can make them appear on every page of a printout by going to FilePage
setup...SheetRows to repeat at top and entering 1:1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Alvin M." <Alvin wrote in message
...
how do I name the columns?

Alvin

If you mean change the A,B,C to something more meaningful such as "Name",
"Address", "City" etc., you can't.

You can use row 1 for your titles then select A2 or B2 if you also want column
A frozen and WindowFreeze Panes.

Now go to ToolsOptionsView and uncheck "Row and Column Headers".


Gord Dibben Excel MVP


On Tue, 25 Jan 2005 18:13:01 -0800, "Alvin M." <Alvin
wrote:

how do I name the columns?