How do I lock a line in Excel?
Thread poster: urst

urst  Identity Verified
Spain
Local time: 14:48
German to Spanish
+ ...
Jan 14, 2005

Hi, I'm working with Excel 2002, Windows XP and I do have an excel file where the first line is 'locked' in place, meaning that it doesn't scroll away, when I scroll down the document. This I found very convenient and I would like to use it for my own lists and things - but I haven't been able to find the gimmick to activate this function. I am sure this is an easy thing to do, I hope, but I am not really Excellent.) Thank you so much

Direct link Reply with quote
 

Gildas Gouardos  Identity Verified
France
Local time: 14:48
English to French
Select row below the row - go to Window > Unfreeze Panes Jan 14, 2005

Hi,

Here is how I usually proceed:

If you want to 'lock' the row 100, select the first cell just below it (in row 101), go to Window > Unfreeze Panes.
Hope this helps

G.


Direct link Reply with quote
 

Csaba Ban  Identity Verified
Hungary
Local time: 14:48
Member (2002)
English to Hungarian
+ ...
with a little correction Jan 14, 2005

When you lock rows or columns, you "Freeze" the panes, when you release this locking, you "unfreeze" them.

To freeze a row or several rows, select the first row that you would like to have scrollable.
To freeze a column or several columns, select the first column that you would like to have scrollable.
You may also freeze one or several rows AND columns. In this case select the first cell (E.g. C3, if you need to fixed rows and two fixed columns).

After selection: Window - Freeze Panes


Direct link Reply with quote
 

urst  Identity Verified
Spain
Local time: 14:48
German to Spanish
+ ...
TOPIC STARTER
Yes, great! That's what I was looking for. Thanks Jan 15, 2005

a lot

Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How do I lock a line in Excel?

Advanced search






Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »
SDL Trados Studio 2017 for €415/$495 with free eLearning
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €415 / $495 / £325 / ¥60,000 For this month only – receive SDL Trados Studio 2017 - Getting Started eLearning for FREE.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search