People usually tend to freeze rows in their Excel sheet when they want to see particular sets of rows in the worksheet. Learn How to Use the IF Function In Excel here. There is a keyboard shortcut as well for freezing the first column only in your Excel sheet regardless of the position of the cursor. Excel will add a dark grey vertical line which indicates that the first column is now frozen. Step 3: Scroll till the right end of the worksheet where the column ends. Step 2: In the next step, you need to click on the ‘Freeze First Column’ option. Step 1: On the View tab, click on the Freeze Panes option again If you want to know how to freeze the first column in your excel spreadsheet, you are required to follow the below-mentioned steps: Excel will automatically add a dark grey horizontal line that indicates that the top row is now frozen.Īpart from that, you can freeze the top row only regardless of where the position of the cursor is using a keyboard shortcut that is Alt-W-F-R.Ĭheck How to Use the Average Function in Excel here. Step 3: In the next step when trying to freeze panes in MS Excel, scroll down at the end of the worksheet. Step 2: After clicking on the Freeze Panes option, you need to click on the ‘Freeze Top Row’ option. Step 1: In the View tab situated at the top, click on the ‘Freeze Panes’ option. If you want to freeze just the top row in your Excel sheet then these are the steps you need to follow:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |