If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I lock column and row names on spreadsheet
I need to lock my column and row names so that as my spreadsheet gets larger
I can still see the titles so I can put the information in the right places |
#2
|
|||
|
|||
Cheryl -
activate the cell that is one row below and one column to the right of your names, then use the menu to choose Window | Freeze Panes "Cheryl D" wrote: I need to lock my column and row names so that as my spreadsheet gets larger I can still see the titles so I can put the information in the right places |
#3
|
|||
|
|||
Hi Cheryl.
You need to go into print preview, settings, sheet. In there you can define which rows and colums you want repeated on all pages. Alternatively you can just choose Window and freece them. Kind regards, Anne "Cheryl D" skrev: I need to lock my column and row names so that as my spreadsheet gets larger I can still see the titles so I can put the information in the right places |
Thread Tools | |
Display Modes | |
|
|