how to freeze panes in excel 2011 for mac

Ze Panes In Excel 2011 How To Use The
Ze Panes In Excel 2011 Software Providers Who

There is 3 type of Freeze Panes option available in View menu tab under Window section, Freeze Panes, Freeze Top Row and Freeze First Column.

Freeze Panes is used to freeze the worksheet from the point where we keep our cursor.

Then to freeze a Row and a Column, we have separate option to freeze each of them.

Once we do that, we will see some portion of the worksheet will not move until we unfreeze it.

This makes it easy to know which parameter we are referring to when we try to analyze data beyond the first few records in the workbook.

The Grey Lines in the middle of the worksheet indicate where the rows and columns have been frozen in place.

Ze Panes In Excel 2011 How To Use The

In the next few paragraphs, we will learn how to use the features associated with freezing panes and using them for analysis.

Select Freeze Panes from the view options, this will open a dropdown menu where there are options to select the rows or columns which we want to freeze.

Select Freeze Top Row, this will freeze the top row of the active worksheet in place and allow us to browse the rest of the data without disturbing the top row.

From the dropdown menu, select Freeze First Column and this would freeze the first column in place, allowing us to browse the rest of the data without disturbing the first column.

As we have seen in the examples, knowing the basic structure of the table helps us decide what we want to freeze.

From the dropdown that appears, select the first option, Freeze Panes.

We just have to go into the freeze panes dropdown and click on Unfreeze Panes as shown below.

Ze Panes In Excel 2011 Software Providers Who

In fact, freezing panes in excel are so useful that there are software providers who provide additional features in based entirely on freezing panes in excel.

One such example is the ability to freeze and unfreeze multiple worksheets and tables at once, which is provided as a product by many software vendors.

There are add ons available from various software providers to enhance these.

Here we discussed How to Freeze Panes in Excel and Different methods to Freeze Panes in Excel along with practical examples and downloadable excel template.

By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.

How To Freeze Panes In Excel 2011 For Mac