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


 

Jaroslaw Michalak  Identity Verified
Poland
Local time: 04:38
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


 

D. Kenyon  Identity Verified
Spain
Local time: 04:38
Member
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.


 

Jaroslaw Michalak  Identity Verified
Poland
Local time: 04:38
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.


 

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


 


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






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



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