Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spreadsheet where categories at side don't move out of view?
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
You need to select the cell to the right and to the bottom of what you want
to see permanently, then go 'Windows' on the Toolbar and click 'Freeze Panes' Regards, Alan. "almann101" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get a listbox to move when scrolling down spreadsheet | Excel Discussion (Misc queries) | |||
Want listbox to move when scrolling down spreadsheet | Excel Discussion (Misc queries) | |||
How do I move the end of the spreadsheet place where (ctrl + end). | Excel Discussion (Misc queries) | |||
how do I move a spreadsheet into word | Excel Worksheet Functions | |||
In Excel can I move the tabs to the left side of the workbook? | Excel Worksheet Functions |