How to Keep Excel Rows from Scrolling

How to use Freeze Pane feature

Grab this video:
Sunshine Red
Sunshine Red, Yahoo! Contributor Network
Feb 22, 2008 "Share your voice on Yahoo! websites. Start Here."

Using this feature in Excel will keep cells from scrolling. This is a great feature if you have allot of rows of data and you want a header row to stay stationary.

Credit: j thomas
Copyright: j thomas

Published by Sunshine Red

I like to research about any and everything.  View profile

7 Comments

Post a Comment
  • thanks..4/19/2011

    it really helped me.

  • Amber5/24/2010

    Awesome, this answered my question. One note is if you have Vista, its under "View", then the box labeled "Window". You click "Freeze Panes" and there are options to freeze the first column, first row, or custom.

  • Matt C10/22/2009

    Hi there,

    Thanks for the tutorial... I doubted whether I'd be able to find this when I googled 'how to keep cells from scrolling'!! cheers

  • Jim9/10/2009

    An easy way is to simply hide the unused columns and rows. Go to the first empty column after your data, select it, use ctrl-shift-right arrow to select all columns to the right and then hide them. Same for rows below last data row...except use the down arrow! ;-)

  • Anonymous2/11/2009

    i was looking for 5 days for such a simble thing and the only thing that i was finding was tips with macros that are difficult to make them work.P L E A S E change the tags of this video or at least add the words "disable scrolling" so other people can find it easily.
    Thanks very mucj for the tip.

  • kimba6/12/2008

    nice and ez thanks to you

  • Harriet Steinberg2/22/2008

    thank you for the very helpful info.

Displaying Comments

To comment, please sign in to your Yahoo! account, or sign up for a new account.