how to freeze panes in excel 2016 for mac

To fix this problem, you can freeze part of the worksheet so that even when you scroll, the headings are displayed.

In order to change the freeze point, you must unfreeze and freeze the cells again.

If you select a cell in the first row, only the columns to the left will freeze (no rows).

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.

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).

How To Freeze Panes In Excel 2016 For Mac