Return to article: How to Use the Freeze Pane Command in Excel to Create Static Headings
on 8/27/2006 If you regularly work with a lot of very large spreadsheets, consider saving keystrokes with a Freeze Panes button on one of your toolbars:Right-click on any toolbarChoose "Customize" at bottom of pop-up menuIn Customize pop-up, Choose "Window and Help" from Categories column on leftScroll right column down about halfway down until you see "Freeze Panes"Left-click on Freeze Panes, keeping your mouse button down, and drag it onto whichever toolbar you want, in whatever position you choose.Click "Close" button.You're done!Bonus tip: You can add a lot of useful buttons to your toolbar this way. While your Customize pop-up is open, consider taking five minutes to browse through all the categories and see whether you could use any of the other useful buttons available to you. All Microsoft Office programs (e.g., Word, PowerPoint) have the same functionality as well.
Copyright © 1999-2008 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.
Partner Sites
