

I tried other options in the drop-down too.

Example- If I want to freeze row 4, I will click in row Row 5, Column A.
#Freeze panes in microsoft excel for mac how to#
When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet. Click in a cell immediately below the rows I wish to freeze. Answer (1 of 3): HI, the following link will guide you for how to use and utilize the Freeze panes option on Excel. 760How do I freeze/fix column or row headings in Excel? In this video, you’ll learn the basics of freezing panes and utilizing view options in Excel 2019, Excel 2016, and Office 365. In Microsoft Excel 2019, 2016, and, you can freeze rows and columns so that when you scroll, those panes stay in place.
