Benefits Of The Freeze Panes Command In Excel 2007

Many of the worksheets that are created Excel contain headings in the top row of the sheet. Normally, when we scroll down the sheet, any headings at the top will disappear. Similarly, if we scroll to the right, any headings on the left will disappear.

The Freeze Panes command, which is located in the View Tab of the Excel Ribbon, allows us to freeze our headings so that, as we scroll the sheet, headings remain in view. Excel gives us three options: firstly, we can choose “Freeze Top Row”. A bold horizontal line is then visible underneath the first row which extends into the row headings. As we scroll down the worksheet, the headings at the top of the sheet will now remain in view. Similarly, we can use the “Freeze First Column” command. This time, the bold line will extend to the right of the first column and into the column heading area.

Then, as we scroll to the right of the worksheet, the first column remains frozen so that we can see the headings it contains and compare them with data in the adjacent cells. To return to normal scrolling, we simply use the “Unfreeze Panes” command in the “Freeze Panes” drop-down menu. Excel also allows us to freeze an arbitrary number of rows and columns. To do this, click in the cell below the last row you want frozen and to the right of the last column you want frozen. So, for example, to freeze the first row and the first column you would click in cell “B2″. Having selected the cell, in the “Freeze Panes” drop-down menu, you would then choose “Freeze Panes”. This time, there are two bold lines: one indicating the column that is frozen and one indicating the row that is frozen.

Then, as we scroll down the first row remains frozen and, similarly, when we scroll to the right the first column remains frozen. Once again, to return to normal behaviour, we simply choose “Unfreeze Panes” in the “Freeze Panes” drop-down menu. Since this command allows us to freeze any number of rows or columns, if you are working on a large worksheet perhaps containing multiple row and column headings, you will probably find it pretty much an essential feature.
Author is a developer and trainer with TrainingCompany. Com , a UK IT training company offering Microsoft Excel 2007Classes at their central London training centre.

Related Posts

Benefits Of The Freeze Panes Command In Excel 2007

Many of the worksheets that are created Excel contain headings in the top row of the sheet. Normally, when we scroll down the sheet, any headings at the top will disappear. Similarly, if we scroll to the right, any headings on the left will...

Getting Some Perspective With Excel’s Split Commands

The Split command is to be found in the View Tab of the Excel Ribbon. It allows users to split an Excel spreadsheet window into either two or four separate panes and is particularly useful for comparing data in different parts of a large wo...

Upgrade To Introduced Office 2010

Microsoft Cheap Office 2010 is a mature software suite. Even Microsoft Word, Excel, Access and PowerPoint in Office 97 suites feature all the current features casual users search. There is very little new features that are actually useful i...

Transferring Microsoft Excel Worksheets Between Workbooks

Microsoft Excel allows you to change the order of worksheets within a workbook at any time. There are two ways to do this, the first of which is simply to drag the tabs representing each worksheet to the left or right. Not only can you drag...

Microsoft Excel 2007 Worksheet Tab Manipulation

Microsoft Excel offers a number of different ways of inserting new sheets into your workbooks. One of the most straightforward methods is to use the Insert Worksheet button. This can be found to the right of the worksheet tabs. Irrespective...

How To Use Print Preview And Quick Print In Microsoft Excel

Excel's Quick Print feature allows you to send a document to the default printer without the need of entering values in a dialog box. If the Quick Print button is not already visible on your Quick Access Toolbar, simply choose it from t...

What’s New If You Buy Office 2010?

Will it be worth my money to buy the next version of Microsoft Office 2010? This is a common question on almost all of Microsoft Office users whenever a new Office is release on the market. For Office 2010, Microsoft has developed two vers...

Office 2010 Need Images To Support

In the past, several experts will learn the different versions of Photoshop and advanced digital imaging techniques to produce only high quality presentations in Word, Excel and PowerPoint. Anyone who does not really know Photoshop could fi...

Be More Productive With Microsoft Excel

Excel was available for Windows at its launch in 1987. It developed the original spreadsheet features to enhance their usability and taking advantage of the new mouse-based interface. Whether you are a professional looking to sharpen your s...

Microsoft Office 2010 Coming

Microsoft intends to release Microsoft Office 2010 Technical Preview to invited guests who register to sign up for Office 2010 CTP Program only by July 2009. Office 2010 was previously known by codename Office 14 (taken cue from its version...

Leave a Reply

Trending Articles