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: 11:43
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: 11:43
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: 11:43
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






SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



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