Able Nevada Reference Blog
Nevada`s Complete Source for Reference
Excel Help Tips Part Three: Freezing In Excel
July 20th, 2010 by admin
Welcome to another session of our Microsoft Excel Tutorial. Due to the overwhelming amount of mail that I have received regarding freezing functions in Excel, we will be covering such functions today. Before we begin, always remember everything we discussed can found in Excel’s help section. All your questions can be answered there. Take the time to read it for reference.
First up, we will answer the question: “how do i freeze a row in excel?”
To begin, choose the row(s) that you want to freeze by clicking the corresponding row heading of your choice. Row headings are the number found on the leftmost side of the sheet. You will know you are successful because the whole selected row will be highlighted after clicking the row heading.
Once you have the rows selected, go to the View tab, look for the Window group, look for the Freeze Row command and you are done.
On to the second question: “how do i freeze panes in excel 2007?”
What you do is basically just the same as above except, aside from selecting rows, you are going to select both rows and columns. After selecting your row of choice, choose the column(s) that you want to freeze by clicking the corresponding column heading of your choice. Column headings are the numbers found on the topmost part of the sheet. You will know you are successful because the whole selected column will be highlighted after clicking the column heading.
Once you have the rows and columns selected, go to the View tab, look for the Window group, look for the Freeze Pane command and you are done.