To unfreeze rows or columns click the freeze panes command then select unfreeze panes from the drop down menu. To unfreeze your panes at any time just click on the view tab and click the freeze panes button then select unfreeze panes.

Weebly Website Start A Business Empire For Free Online

Here we want to freeze row five and column b so we ll select cell c6 by clicking it.

Freeze panes excel 2013. If you only need to freeze the top row row 1 or first column column a in the worksheet you can simply select freeze top row or freeze first column from the drop down menu. This will now freeze all the rows above row 6. Due to changes with how windows are containerized in excel 2013 and later you no longer protect windows in those versions when protecting a workbook.

Freezing only the top row of a workbook. The next step is to go back to freeze panes and choose freeze panes this time instead of freeze top row. Excel 2013 select the row below the row s you want to freeze select row 6 if you want to freeze rows 1 to 5.

Excel 2016 excel 2019 office 365. On the view tab click freeze panes freeze panes. Freezing rows or columns in excel isn t.

If the drop down menu says unfreeze panes instead then you will need to click that first to remove the existing frozen pane then click the freeze panes button. Learn how your comment data is processed. You can also use panes to freeze headings in the top rows and first columns so that the headings stay in view at all times no matter how you scroll through the worksheet.

Excel s freeze panes command also becomes disabled when the workbook is protected in excel 2010 and earlier as illustrated in figure 2. The same method in the section above will work. Panes are great for viewing different parts of the same worksheet that normally can t be seen together in excel 2013.

Less to keep an area of a worksheet visible while you scroll to another area of the worksheet go to the view tab where you can freeze panes to lock specific rows and columns in place or you can split panes to create separate windows of. Click the freeze panes button in the window section of the navigational ribbon then click the freeze panes option on the drop down menu. Excel for microsoft 365 excel for the web excel 2019 excel 2016 excel 2013 excel 2010 excel 2007 more.

Now you can scroll through the data while the four rows of data for standid 1001 year 2013 and productid a10011 remain visible. This site uses akismet to reduce spam. Next switch to the view tab click the freeze panes dropdown menu and then click freeze panes and now we can scroll down or right while keeping those header rows and columns on screen.