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

Similar Threads

Access Lock File .LACCDB / Now shows as a notepad file 0
Need Help with a VBA subroutine 0
Format column widths from one table to a separate table on same page 1
Integrating information from Word to Excel (not mail merge) 1
Dealing with a Pivot Table (when I don't want to) 0
Extracting a cell value 2
Alternate Row Shading with Filter 1
Place picture in Excel cell 0

Top