Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there a way to freeze a column(s) or row(s) in place so that when I scroll up or down my worksheet, the column(s) or row(s) remain visible?

share|improve this question
    
I'm not sure that I understand what you mean by "move across" –  EBGreen Jan 24 '12 at 18:37
    
Do you mean freeze the column so that scrolling to the right leaves that column in place on the screen where it is? –  Shane Wealti Jan 24 '12 at 19:08
add comment

3 Answers

Office 2010, do the following:

  1. Make your selection that you want to remain in place
  2. Go to ribbon view - freeze panes
  3. Choose to freeze the top row the first column or your selection
  4. The chosen selection will be frozen in place as you move up or down the sheet
share|improve this answer
    
i figured it out!!!! thank you. freeze panes! –  Brad Cappon Jan 24 '12 at 21:06
add comment

You can't do only specific column.

But you can target specific column and that corresponding row using

View Menu --> Freeze Pane

Example: If you are on Cell F5 (that is column F & row 5) and select Freeze Pane from View Menu then

Freezed Column will be, till Column E
Freezed Row will be, till Row 4

EDIT:

For more clarity, refer this screenshot:-

enter image description here

share|improve this answer
    
i have a list of names and my excel sheet is very long horizontally. i loose track of which row the name is in while looking further to the right. is there a way to have the list of names move across the spreadsheet while i look further down –  Brad Cappon Jan 24 '12 at 21:05
    
yes, you can do by using Freeze Pane. Assuming if your Row 5 contains names in each cell then select the CELL A6 then Click on View Menu --> Freeze Pane. Now try by scrolling vertically, you will see Row 5 as freezed. –  Siva Charan Jan 25 '12 at 7:47
    
This answer is misleading. You can freeze a specific column or row, it will just become the top-most or left-most column/row or all rows/columns to the left/top of it will also remain frozen. –  Raystafarian Feb 8 '12 at 12:49
    
sorry raystafarian, i think you might not looked properly. I have explained clearly how it works.. there is something, you mistaken my answer.. –  Siva Charan Feb 8 '12 at 14:05
    
@Raystafarian: I have updated my answer with screenshot, for your reference. –  Siva Charan Feb 8 '12 at 14:11
show 2 more comments

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

Excel 2010

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.