Have Excel make a column permanent

August 26, 2006 at 05:52:04
Specs: xp home, p4 1 gb

I have a spreadsheet with Excel that has tons of columns. It goes waaaay right. How can I make the first column stick or permanent when I scroll right so that I can always view that column? Thanks

See More: Have Excel make a column permanent

Report •


#1
August 26, 2006 at 06:38:02

Highlight columns A abd B, then from the menu along the topselect Window < Freeze Panes

Michael J


Report •

#2
August 26, 2006 at 08:54:06

Thanks for the tip, this freeze a number of columns and/or rows, is there a way to just freeze one specific column?

Report •

#3
August 26, 2006 at 09:58:32

Just select column A or the column you want to freeze.

Report •

Related Solutions

#4
August 26, 2006 at 10:21:18

Actually you want to select the column next to the one you want to freeze. Same for rows, select the row under the one you want to freeze.

To freeze col A, select B then freeze.


Report •

#5
August 26, 2006 at 23:10:03

If you would follow the steps I gave it WOULD do exactly what you asked for.

Michael J


Report •


Ask Question