How do I freeze first row and first column in Excel?

How can I lock both column and rows at the same time using the 'freeze panes' in Excel?

I can manage to freeze either columns or rows, but not both. I can do a similar thing with "split panes", but this isn't quite what I want.

Malachi

1,0731 gold badge11 silver badges26 bronze badges

asked Jan 6, 2010 at 21:24

0

Click on the cell just to the right of the column, and just below the row you want to freeze, and then select View→Window→Freeze Panes→Freeze Panes.

So, if you want to freeze row 1 and the column A, click on B2 and select View→Window→Freeze Panes→Freeze Panes.

If you want to freeze rows 1:3 and columns A:B, click on C4 and select "Freeze Panes".

robinCTS

4,2974 gold badges19 silver badges29 bronze badges

answered Jan 6, 2010 at 21:37

SnarkSnark

31.7k7 gold badges85 silver badges94 bronze badges

4

Additional Help

Freeze or Lock Rows and Columns

I found it Very Difficult to figure out how to do this for the Top row and for a couple of Columns. I did figure it out however,

First Split the panes

and then move the large black Lines to the rows and columns that you want Static (or Fixed)

you can click Freeze panes > Freeze Panes and then click Split or you can just click Split. if you do anything else in the Freeze Panes and then Try to Split it will only Give you One Thick Black Line.

if your focus is in the are that is Static (Fixed/Locked) and try to scroll you will scroll only that pane.

I am using Excel 2010

answered Oct 19, 2012 at 15:03

MalachiMalachi

1,0731 gold badge11 silver badges26 bronze badges

1. Click on Cell, from where you want to freeze the pane.
2. Click on Split, a thick bar will appear. If you see closely you will find that it has created a pane.
3. In my case I selected Cell B10.
4. Click on Freeze pane, then again click freeze pane option. There you go you have frozen a column and row at a time.

answered Aug 9, 2014 at 15:25

Key is to simply click the Freeze Panes button rather than select the arrow on button. Clicking the Freeze Panes button will freeze both rows and columns according to the pane you've selected, whereas selecting the menu arrow on the Freeze Panes button forces you to select only one option.

answered Jul 9, 2014 at 19:40

Here is a VBA snippet that may help with this.

Columns("D:D").Select With ActiveWindow .SplitColumn = 1 .SplitRow = 0 End With ActiveWindow.FreezePanes = True Rows("1:1").Select With ActiveWindow .SplitColumn = 1 .SplitRow = 1 End With ActiveWindow.FreezePanes = True

Excellll

12.5k11 gold badges50 silver badges78 bronze badges

answered Oct 27, 2014 at 17:09

Topics Map > Office 365 > Excel

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 the same worksheet.

---

Freezing panes versus splitting panes

When you freeze panes, Microsoft Excel keeps specific rows or columns visible when you scroll in the worksheet. For example, if the first row in your spreadsheet contains headers, you might freeze that row to make sure that the column headers remain visible as you scroll down in your spreadsheet.

A solid line under row 1 indicates that the row is frozen to keep column headers in place when you scroll.

Splitting panes is a variation on freezing panes, in that when you split panes, Excel creates either two or four separate worksheet areas that you can scroll within, while rows or columns in the non-scrolled area remain visible.

Note: You cannot freeze panes and split panes at the same time. You can enable only one of the two.

Freeze rows or columns

Before you choose to freeze rows or columns in a worksheet, it’s important to consider the following:

• You can freeze only rows at the top and columns on the left side of the worksheet. You cannot freeze rows and columns in the middle of the worksheet.

• The Freeze Panes command is not available when you're in cell editing mode (that is, you're entering a formula or data in a cell) or when a worksheet is protected. To cancel cell editing mode, press Enter or Esc.

You can choose to freeze just the top row of your worksheet, just the left column of your worksheet, or multiple rows and columns simultaneously. For example, if you freeze row 1 and then decide to freeze column A, row 1 will no longer be frozen. If you want to freeze both rows and columns, you need to freeze them at the same time.

1. Do one of the following:

   • To lock one row only, choose the View tab, and then click Freeze Top Row.

   • To lock one column only, choose the View tab, and then click Freeze First Column.

   • To lock more than one row or column, or to lock both rows and columns at the same time, choose the View tab, and then click Freeze Panes. You will want your cursor to be below the row(s) you want to freeze and to the right of any column(s) you want to freeze.

   • To lock multiple rows (starting with row 1), select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes.

   • To lock multiple columns, select the column to the right of the last column you want frozen, choose the View tab, and then click Freeze Panes.

Note: If you don’t see the View tab, it’s likely that you are using Excel Starter. 

Freeze the top row and the first column at the same time

To freeze the top row and the first column at the same time, click the View tab > Freeze Panes > Freeze Panes.

Freeze the top row

Notice that the border under row 1 is a little darker than other borders, meaning that the row above it is frozen.

Freeze the first column

If you'd rather freeze the leftmost column instead, click the View tab > Freeze Panes > Freeze First Column.

Now, the line to the right of column A is a little darker than the other lines, meaning that the column to its left is frozen.

Unfreeze rows or columns

• On the View tab > Window > Unfreeze Panes.