➤ Select cell B2 and click on this Freeze Panes icon. To freeze the top row and first column with this magic button, Now, you will see a Freeze Panes icon in the top bar of your Excel file. It will add the Freeze Panes option in the right box. ➤ Select Choose Not in the Ribbon in the Choose Command from box. ➤ Click on the drop-down icon from the top bar of the Excel files.Īs a result, the Quick Access Toolbar tab of the Excel Options window will appear. First, let’s see how to create this magic freeze button. With this button, you can freeze the top row and the first column very easily. If you frequently need to freeze rows and columns, you can enable a Magic Freeze Button. Magic Freeze Button to freeze Top Row and First Column Related Content: Keyboard Shortcut to Freeze Panes in Excel (3 Shortcuts)ĥ. You will always see the top row and the first column of the sheet regardless of how far you go in the worksheet. ➤ Go to the View tab and click on the Split icon.Īs a result, the top row and the first column of your dataset will be frozen. You can also use Split Panes to freeze the top row and the first column of your datasheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |