Mobile menu

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: 06: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


Direct link Reply with quote
 

dekken  Identity Verified
Spain
Local time: 06:38
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: 06: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.


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






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 »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »



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