haahope.blogg.se - Microsoft excel 2011 how to freeze first two columns

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. However, its most common use will be doing what we have done in this tutorial. 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. Now try scrolling your mouse to the right. That is because this line marks off the frozen cells on the left from the unfrozen cells on the right. 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. By selecting cell B1 and then choosing Freeze Panes, you have frozen all the cells in Column A. A bar will appear between Column A and Column B. Once you have selected cell B1, click Window > Freeze Panes. Use Normal view.įrom Normal view, select the first cell in column B, cell B1. Freeze Panes will not work in Page Layout view. Freeze Panes allows the user to freeze a column and scroll through the rest while the frozen column remains in the same place.įor our example, we will be working with a spreadsheet that lists Type in the first column, and then has further classifications about that Type in the succeeding rows.īefore we begin, make sure you are not viewing your Excel file in Page Layout view. The only difference is that this time you’ll have to select the “Freeze First Column” command on the dropdown list at the top.This feature can be especially helpful for users who have a spreadsheet that is more horizontally than vertically oriented. If you wish to freeze the first column instead, the process is pretty much the same. Once a row has been frozen, Excel automatically inserts a thin gray line below it.

From the options listed, select “Freeze Top Row.” This will freeze the first row, no matter what row you happen to have currently selected.

Click on the “View” tab at the top and select the “Freeze Panes” command.

Alternately, click on any cell along the row and then press “Shift” and the spacebar. To do so, you need to select the row number on the extreme left.

Open the Excel worksheet and select the row you wish to freeze.

This is usually the top row in your workbook.

How to Freeze a Single Row on Excelįirst, let’s see how you can freeze a single row of data.

It works pretty much like using pins or staples to hold large bundles of paper in an orderly, organized manner. This helps you to remember exactly what kind of data a given row or column contains. As the name suggests, freezing holds in place rows or columns of data as you scroll through your worksheet.