How to freeze column in excel 2007

how to freeze column in excel 2007
Don't you believe me? Most obviously, rows 1 - 3 would get frozen? September 21, at 7:

To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll source.

Freeze panes to lock rows and columns

Now go to the View ribbon and click Freeze Panes. Choose the first option which will freeze the columns and rows to the left and above your selection. If you want to keep all of columns A: H and all of row 1 always visible: Select cell I2 and then click on 'Freeze Panes' option.

how to freeze column in excel 2007

By posting your answer, you agree to the privacy policy and terms of service. Questions Tags Users Badges Unanswered. Super User is a question and answer site for computer enthusiasts and power users.

Join them; it only takes a minute: You will now see 2 solid lines which indicates that anything to the left and above those lines are frozen.

How to freeze panes in Excel to lock rows and columns

Hope this helps and happy scrolling. This is so helpful.

how to freeze column in excel 2007

Thank u so much. Eish this was so handy, this was the second time I tried to do this with no joy, until I saw this solution from miss b. 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 1select the row below the last row you want frozen, choose the View tab, and then click Freeze Panes.

how to freeze column in excel 2007

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. Notice that the border under row 1 is a little darker than other borders, meaning that the row above it is frozen.

how to freeze column in excel 2007

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. Post a question in the Excel Community forum. Do you have suggestions about how we can improve the next version of Excel? If so, please check out the topics at Excel User Voice. Freeze panes to lock the first row or column in Excel for Mac.

how to freeze column in excel 2007

Split panes to lock rows or columns in separate worksheet areas. 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.

To freeze rows above and to the left of a cell.

how to freeze column in excel 2007

Select for example cell B2, then press the Ctrl and C simultaneously, this will highlight cell B2 and then select Freeze Panes and now both the rows and columns are frozen. By posting your answer, you agree to the privacy policy and terms of service. Questions Tags Users Badges Unanswered.

Freezing Panes in an Excel 2007 Worksheet

Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top.

Freeze row and columns in Excel at the same time.

how to freeze column in excel 2007

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