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 |
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 |
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 |
All times are GMT +1. The time now is 12:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com