column and row headings

G

Guest

Using Office 2000 (Excel), how can I keep my column and row headings
stationary and still be able to scroll through the rest of my worksheet? I
would like to create a home budget in which I can track my daily spending.
 
R

Roger Govier

Hi

Place your cursor in cell B2.
Windows>Freeze Panes

Regards

Roger Govier
 
M

Mladen_Dj

Go to Window->Freeze Panes. Excel will freeze left-columns and up-rows from
active cell. for example if your row headings are in column A, and column
headings in row 1, select cell B2,and row 1 and column A will be
unscrollable.
 

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

I don't want row 1 as the column headings 1
Printing a Different Row Heading Mid-way through a Spreadsheet 1
Trying to add column headings to array formula 1
Colume Headings 1
Adding cels in a row that correspond to the heading of a column 2
Print Column Heads WITHOUT Excel Column Lables 1
Summing based on values in other worksheets 2
Freezing column headings 2

Top