View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
John John is offline
external usenet poster
 
Posts: 2,069
Default Setting up Excel worksheet

You can't change the a,b,c etc column letters to something else. You need to
add the headings in row 1. You could lso add the row numbers you want in
column 1 so your data starts in cell B2.

To keep these headings you need to click in cell b2 and then windowsfreeze
panes
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Lee H." wrote:

How to get Column Headings to show up where A, B, C, D, etc. are?

This allows user to start data on A1/Row #1 so that the numbering works
automatically. Column labels above Row #1 will also allow the
labels/headings to appear on each page of the worksheet and not just A, B, C,
D, etc.