![]() To do this you need to choose an active cell. You can choose which columns and rows you want to freeze other than the one at the top and on the left. You can check if it has worked by scrolling down or across and checking whether the top row or the left hand column stays in place. Once you have done this then a thick black line should appear below the top row or the first column. ![]() You can click on just one of these options or both of them, depending on what you need for your spreadsheet.ģ. ![]() This will open a drop-down menu where you will find an option to Freeze Top Row and Freeze First Column, which you should click on. In the center of the ribbon, there is an option for Freeze Panes Excel. Click on the View tab, which can be found in the ribbon at the top of the screen.Ģ.Here you will find an answer to the query, how to freeze panes in excel as well as how you can unfreeze rows and columns. Freezing panes in excel let you keep this information in view at all times and several options exist when using this feature. When you are working with large spreadsheets in Excel, it is very useful to have the headings at the top of the columns and the left of the rows to remain in place so you can see what data you are looking at or entering.
0 Comments
Leave a Reply. |