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.
Related:
When creating reports and presentations, it would be hard to miss out on including any excel files, documents, charts and formatted table. Microsoft is such a powerful tool that an expert or beginner can rely on to from simple computations, charts, pivot, graphs to complicated macros, auto-fill and more. I
In our early years, we were being taught by our teachers in grade school the basics of the computer, its history and the different applications that were made available. I remember the time how my computer teacher would assist us on how to use Lotus 1-2-3 and Word
Microsoft Excel is arguably the best invention for reporting, tabulation and statistical analysis. Getting help with excel macros, formula, charts and formatting would make things easier for someone who wants a polished reports. Imagine the many calculations you can do with so many sheets at the same time. Using excel