Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Alvin M.
 
Posts: n/a
Default How do I add header information to an Excel file? In other words,.

how do I name the columns?
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 06:37 AM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 01:37 AM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 11:20 PM
double click a xls file and start Excel but without the file Danyi, Attila Excel Discussion (Misc queries) 2 December 22nd 04 03:19 PM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"