how to freeze panes in excel for mac 2011

Ze Panes In Excel 2011 Download The Workbook

Like freezing top row means the very first row of the worksheet and similarly freezing top column or first column means the very first column of the worksheet irrespective of where your data starts.

Ze Panes In Excel 2011 Download The Workbook

Download the workbook to get access to the large data set and see the live impacts of freezing the columns in excel.

You have frozen your first column to see column A when you are scrolling from left to right.

If I want to freeze the first 4 columns then I need to place my cursor in the fifth column.

In this I will place a cursor in the E1 cell, refer above image.

We can see the straight gray line which indicates the frozen line.

Right now I am in the last column still I can see the first 4 columns which are frozen.

Usually in excel first row contains our headers and the first column contains the column headers.

This enables me to see the top row while scrolling down and see the first column while scrolling from left to right.

But while selecting multiple rows we have selected the first column cell and while freezing multiple columns we have selected the first row.

You need to be very sure how many rows and how many columns you need to freeze exactly.

It will freeze panes for you i.e.

CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute.

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 For Mac 2011