Naming columns

[R_Brown]

Hello group,

I have a worksheet for our small business to keep track of all the
financial data. I would find it alot easier if the columns could be
changed from "a", "b", "c", etc. to have the name of the data which
goes in that column, for instance "courier" "power bill" "vendor" etc.
THe problem is when I am entering data in a column on say line 100, and
cannot remember what that column is. Currently, I have a paper cheat
sheet indicating what each column is for, but I would rather change is
on the program. I hope I am describing my question properly,

Thanks in advance,

RB

 

[Hank Scorpio]

On Fri, 19 Sep 2003 18:48:30 -0400, R_Brown

All you need to do is freeze the window panes so that your top row
(containing the column heading) is always visible. Put your cursor in
cell A2 and go to the Window menu, and select Freeze Panes.

 

[pfsardella]

1. Place your headings in Row 1.
2. Select all of Row 2.
3. On the MenuBar, select Windows > Freeze Panes.

This will keep your column labels at the top of your worksheet.

HTH
Paul