Shortcut key of Freeze panes: - Alt+W,F,F. When you have a huge amount of data under a common heading you are unable to see the heading when scrolled down the worksheet. What freeze panes does is it lets you freeze particular rows and columns of your choice so that you can see that frozen portion even when the rest of the datas are being scrolled. You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice. Freeze panes to lock the first row or column in Excel 2016 for Mac. Split panes to lock rows or columns in separate worksheet areas. Overview of formulas in Excel.
In my recent overview of the iWork ‘09, I mentioned the new Freeze Header feature in Numbers. This feature is basically the same as the Freeze Pane function in Microsoft Excel. It lets you set one or more rows or columns to always stay visible, even when scrolling around a large spreadsheet.
Since I’ve been seeing some people searching the Web for information on how to use this new feature, I thought I’d post this quick tip here.
The Freeze Pane function in Numbers ‘09 works a bit different than in Excel. In Numbers, you can only freeze header rows and columns. These headers are special in that Numbers knows that they’re not part of the actual data in a table, but rather sort of a “label” for the respective rows and columns.
Excel Mac Lock First Row
Use Table Inspector in Numbers
To define header rows and columns, open up the Inspector by selecting View → Show Inspector in the menu (or by pressing ⌘⌥I) and select the Table Inspector (third from the left).
Excel 2016 Mac Freeze Panes
The second section from above is labeled Headers & Footer. Here you can select how many header rows or columns you want your table to have. And at the bottom of those menus, you can select if you want the headers to be frozen.