Hello,
I saw another topic where in the example there are a few rows than don't move when you scrool down. How can I make that?
I have attached the example. I am talking about the first three rows on the Database and Inventory sheets.
Hello,
I saw another topic where in the example there are a few rows than don't move when you scrool down. How can I make that?
I have attached the example. I am talking about the first three rows on the Database and Inventory sheets.
Last edited by kitu_gudu; 12-25-2011 at 11:11 AM.
This is called FREEZE PANES. To freeze rows 1:3 onscreen:
1) scroll all the way to the top so you can see cell A1
2) Click on A4
3) In the Window group of the View tab, choose Freeze Panes→Freeze Panes.
The trick to freezing is you must select the cell that represents the first cell to NOT freeze. Everything above and the left will be frozen.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Wow... That was fast. It works. Thank you very much.
How can I make multiple freezes? Let's say I freeze the first three rows, then I leave a few empty rows and freeze again. And after that I can insert rows between the first freeze and the second and I have a scrool bar. Can this be made?
Sorry if my english is wrong. BTW I gave you a star.
Last edited by kitu_gudu; 12-24-2011 at 05:18 AM.
No. You can freeze based on one cell on the sheet. Everything above and to the left will freeze.
OK. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks