![]() ![]() Gain expertise in the latest Business analytics tools and techniques with the Business Analyst Master's Program. Add the Freeze Panes option to the quick access toolbar and click OK.Īs you can see, it adds the shortcut to your toolbar.Click on the down arrow and click more commands.To add the magic freeze shortcut to the quick access toolbar, follow these steps: The magic freeze button is a shortcut to freeze the rows and columns with a single click. In a similar way, you can freeze multiple columns as well. Go to View tab > Windows group > Freeze Panes.Īs you can see below, it freezes all the rows above row 5.To freeze the multiple rows, follow these steps: Excel provides you with the option to freeze multiple rows at once. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |