View Single Post
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

Click on cell B1 and then go to Window (the menu) | Freeze Panes. Then,
Column A should always be visible.

If you click into B2 and then go to Window | Freeze Panes, then Column A and
Row 1 will stay on the screen.

Basically, any rows/columns above or to the left of the cell you click on
will remain on the screen.

--
tj


"almann101" wrote:

In the left hand column of my budget spreadsheet I have the various
categories of income and expenditure listed with their relevant dates etc.
This is fine when I am on the same page as the left hand column however, once
I scroll across I lose sight of what each row corresponds to and they simply
become numbers.

How do I create a left hand margin or column which will scrioll along almost
like a picture frame around my work so I can always see what each cell
relates to more clearly?

Many thanks