Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

MS excel question (viewing first columns/rows when scrolling)

SanderJKSanderJK Crocodylus Pontifex SinterklasicusMadrid, 3000 ADRegistered User regular
edited November 2007 in Help / Advice Forum
I'm working in a rather big table in Excel atm, and i remember that it's possible to select a number of rows and/or columns to always stay visible, while you scroll through the rest. However, cannot recall how to do this. Anyone able to help me remember?

Thanks in advance.

Steam: SanderJK Origin: SanderJK
SanderJK on

Posts

  • ChuweroChuwero Registered User regular
    edited November 2007
    What you're looking for is the 'Preeze Panes' option on the Window menu. You can highlight a row or column and all rows or columns before it will freeze where they are currently displayed. To turn if off, the option will turn to 'Unfreeze Panes' instead if 'Freeze Panes'. You'll probably need to play around with it for a while to get the right setup for your spreadsheet.

    Chuwero on
Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum