Odd behaviors in Excel aside, there are two common situations that can prevent you from being able to access the Freeze Panes command in Excel. Press the letter corresponding to a Ribbon tab to see the key tips for all of the commands on that tab. Press and release Alt in Excel to see key tips for each tab in the Ribbon (plus numbered key tips for the Quick Access Toolbar.
There are hundreds more shortcuts like this which you can easily learn. Split panes to lock rows or columns in separate worksheet areas. Freeze panes to lock the first row or column in Excel 2016 for Mac. 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. It will help you navigate through the sheet 10X easier. Now you may wonder how freezing rows can be somebody’s voluntary choice? Well, freezing rows or columns in Excel can help you maintain the records with ease. For example, many people do not know how to freeze multiple rows in Excel. Excel sheets have a slew of features, and many of you may not even know about all of them. You can perform complicated calculations, keep a record of lengthy records, etc.
Excel Freeze Panes Freezing Too Many RowsĮxcel sheets have made things way easier for people from all over the world.
