how do I lock column and row names on spreadsheet

C

Cheryl D

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
 
D

Duke Carey

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
 
A

AnneKragh

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:
 
Top