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

  • Thread starter Thread starter Guest
  • Start date Start date
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 Window>Freeze Panes.

You can make them appear on every page of a printout by going to File>Page
setup...>Sheet>Rows to repeat at top and entering 1:1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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 Window>Freeze Panes.

Now go to Tools>Options>View and uncheck "Row and Column Headers".


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Continued Headers on successive pages in an Excel document 3
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Word to Excel: Export comments with text and line number 0
Excel How to Fix Damaged Excel File That Won't Open? 3
setting a different size header column and then smaller sub colum. 2
How do I put a heading even with a column? 5
macro 4

Back
Top