ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Locking rows (https://www.excelbanter.com/excel-discussion-misc-queries/131494-locking-rows.html)

sthomas

Locking rows
 
I want to lock 1 row as a header row that will be displayed on the top row of
each page in a document. I'm not familiar with what protecting the sheet
entails, I just need to lock a certain row so that it appears the same on
each page.
--
sthomas

John

Locking rows
 
Go to file/page setup/sheet/ rows to repeat and click on the row number you
want to have on each page
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"sthomas" wrote:

I want to lock 1 row as a header row that will be displayed on the top row of
each page in a document. I'm not familiar with what protecting the sheet
entails, I just need to lock a certain row so that it appears the same on
each page.
--
sthomas



All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com