To remove the pane(s), go back to the Freeze Panes icon in the Window group, and and you will now see the option Unfreeze Pane.

Adjust the split so that the first row (or two) is the only row in the top pane.

This can be very useful to manipulate your data see the Sorting Data section for more information.

University Avenue Ann Arbor, MI 48109-1190 (734) 764-0400 contact-mlibraryumich.edu.

You can also use panes to freeze headings in the top rows and first columns so that the headings stay in view at all times, no matter how you scroll through the worksheet.

The Income Analysis worksheet contains more rows and columns than you can see at one time (unless you decrease the magnification to about 40 with Zoom, which makes the data too small to read).

In fact, this worksheet continues down to row 52 and over to column P.

Additionally, you can keep the row headings in column A on the screen while you scroll the worksheet to the right.

In this figure, the worksheet has been scrolled up so that rows 33 through 52 of the table appear under rows 1 and 2.

Because the vertical pane with the worksheet title and column headings is frozen, it remains onscreen.

Normally, rows 1 and 2 would have been the first to disappear when you scroll the worksheet up.).

In this figure, I the worksheet is scrolled right so that the data in columns M through P appear after the data in column A.

Because the first column is frozen, it remains onscreen, helping you identify the various categories of income and expenses for each month.

Choosing this option removes the panes, indicating that Excel has unfrozen them.

Greg wrote his first computer book more than twenty years ago and since that time, he has amassed a long list of bestselling titles including Excel All-In-One For Dummies (all editions) and Excel Workbook For Dummies (all editions).

Freeze Frames In Excel For Mac 2015