Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add header information to an Excel file? In other words,.
how do I name the columns?
|
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
double click a xls file and start Excel but without the file | Excel Discussion (Misc queries) |