how do you move a column across my excel while viewing other columns?

Question

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?

I'm not sure that I understand what you mean by "move across"
Do you mean freeze the column so that scrolling to the right leaves that column in place on the screen where it is?

Raystafarian · Answer 1 · 2012-02-08 13:26:12Z

Office 2010, do the following:

Siva Charan · Answer 2 · 2012-02-08 14:09:52Z

up vote 2 down vote

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

answered Jan 24 at 19:10

	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 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 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 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 at 14:05
	@Raystafarian: I have updated my answer with screenshot, for your reference. – Siva Charan Feb 8 at 14:11

feedback