Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Locking a row in Excel

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Locking a row in Excel

Old 07-11-01, 06:49 PM
Thread Starter
Join Date: Oct 1999
Posts: 137
Likes: 0
Received 0 Likes on 0 Posts
Locking a row in Excel

I want to lock the first row in Excel so that it never scrolls off the page and always is the first row. I have seen this done before. The other rows can scroll freely.
Old 07-11-01, 06:57 PM
DVD Talk Gold Edition
Join Date: Feb 1999
Location: HB, CA
Posts: 2,600
Likes: 0
Received 0 Likes on 0 Posts
I'm sure there's an easier way to do this, but I've never bothered to figure it out.

Select the first row, under the Windows menu in the toolbar, select Split. Drag the vertical split all the way to the left so that it disappears. Drag the horizontal split up so that it's under row 1. Now with row 1 still selected, go again under the Windows menu and select freeze.
Old 07-11-01, 07:10 PM
Thread Starter
Join Date: Oct 1999
Posts: 137
Likes: 0
Received 0 Likes on 0 Posts
Thanks, that's exactly what I wanted.
Old 07-13-01, 11:02 PM
DVD Talk Limited Edition
Join Date: Jan 2000
Location: Rockford IL
Posts: 5,919
Received 14 Likes on 11 Posts
Better still...

Click on the number corresponding with the row UNDER the one you want to lock (if it's just row 1, click on 2). This will highlight the row.

Go to Window, and select Freeze Panes.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information -

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.