You can remove the split simply by clicking the Split button again. To split this worksheet as shown above, you select below the row where you want the split – selecting row 13 splits the worksheet below row 12.

Would you like to know how to see his result together with the top 10 finishers at the top of the worksheet?īy splitting the worksheet, you can scroll down in the lower pane and still see the top rows in the upper pane. You found his name down in row 180 of your spreadsheet. Your friend Tomas finished a 5-K run last weekend, and you want to see the times of the top 10 finishers to compare his time with theirs. If you want to restrict the input in your cell, then you can create a dropdown.Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 More. Want to know more about how to use the quick access toolbar in excel? Visit this tutorial! If you place your freeze panes button in your quick access toolbar, then you can access it much easier.

The shortcut is by pressing Alt + W and then F and then F. If you use Windows OS, then you can use a shortcut to freeze/unfreeze panes in excel. Go to View > Freeze Panes > Unfreeze Panes.To unlock all the rows and columns, follow the steps mentioned below: 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. 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: With this utility you can now quickly do this on multiple sheets at once. In Excel you can only freeze the panes on one sheet at a time. For example, keeping row and column labels visible as you scroll. If you have selected multiple sheets, it will work on those selected sheets.įreezing panes allows you to select data that remains visible when scrolling in a sheet. If you have selected only one sheet the utility works on all worksheets in your workbook. This utility freezes the panes in all or all selected worksheets, based on your selected range.

Hot to freeze multiple panes in excel