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:
 

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

Top