Freeze Panes will not work in Page Layout view. Use Normal view.įrom Normal view, select the first cell in column B, cell B1.
Once you have selected cell B1, click Window > Freeze Panes. A bar will appear between Column A and Column B. By selecting cell B1 and then choosing Freeze Panes, you have frozen all the cells in Column A. In the screenshot, you can see that the line dividing Column A from Column B is darker than the other lines between the other columns. That is because this line marks off the frozen cells on the left from the unfrozen cells on the right. Now try scrolling your mouse to the right. You will notice that all of the columns and their headings move with your mouse, except for the contents of Column A, which in our example is Type, A, and B.įreeze panes can be applied to any column. However, its most common use will be doing what we have done in this tutorial. If you have many columns with data, you can scroll through them and know exactly what they refer back to at the beginning of the spreadsheet. This same principle can be applied to rows, which is covered in another tutorial.
MICROSOFT EXCEL 2011 HOW TO FREEZE FIRST TWO COLUMNS MANUAL.
0 kommentar(er)
