Fairly basic Excel question
Thread poster: David Jessop

David Jessop  Identity Verified
Spain
Member
Spanish to English
+ ...
Apr 17, 2009

I admit this is a rather basic Excel question but I am not an expert and cannot find the answer on any of the online resources! I have created an Excel sheet for my accounting and am trying to do what I am calling a “scroll lock” for the first row. That is to say that I want to be able to see, for example. “Customer Name” in the first row and then be able to scroll down say 40 rows and the first row “Customer Name” shall still appear. Does my description make sense? I am sure anyone who knows anything about Excel will be able to help me, thank you in advance!

Best,
David


Direct link Reply with quote
 

Jabberwock  Identity Verified
Poland
Local time: 07:37
Member (2004)
English to Polish
Sure you can Apr 17, 2009

Here is description of the solution:

http://office.microsoft.com/en-us/excel/HP052038611033.aspx


Direct link Reply with quote
 

dekken  Identity Verified
Spain
Local time: 07:37
Spanish to English
+ ...
Split and freeze panes Apr 17, 2009

Hi David,
Click on the Window menu, then Split
Drag the horizontal bar that appears on the page up to row one (if that's the only row you wish to keep in view), then on the Window menu click freeze panes. You can then scroll up and down to view the rest of the rows and the first row will not move.

If you don't need the vertical split just drag it off to the left of the page.


Direct link Reply with quote
 

Jabberwock  Identity Verified
Poland
Local time: 07:37
Member (2004)
English to Polish
Easier way... Apr 17, 2009

Actually, you can do it without splitting separately (the article I quoted was not too clear on that).

All you need to do is to select the next row (ie. row 2) and use Window/Freeze panes.


Direct link Reply with quote
 

David Jessop  Identity Verified
Spain
Member
Spanish to English
+ ...
TOPIC STARTER
Thank you! Apr 17, 2009

Hey, Freeze Panes did the trick, thank you to both of you!

Best,
David


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 »

Fairly basic Excel question

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 »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



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