Friday, March 15, 2013

How to Use the Freeze Pane Command to Create Static Headings in Excel 2003


1. Open your Excel worksheet once you have logged on to your computer. You should be able to locate the program by using your 'Start' button. When you cannot find it there, use your 'Search' or 'Find' function.
2. Highlight the column to the right of the column to be frozen. Go to 'Window'. Select 'Freeze Panes'. A bold line will appear to the right of the frozen column indicating that those panes are frozen.
3. Freeze rows by highlighting the row below the row to be frozen. Repeat Step 3 as needed.
4. Freeze both by highlighting the cell to the right of the column and below the row and repeating Step 3.
5. Enjoy scrolling through your worksheet while your titles stay in place.

Blogger news