Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Have Excel make a column permanent

Comment:

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

Reply:

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

0

Reply:

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

0

Name: Bryco
Date: August 26, 2006 at 09:58:32 Pacific

Reply:

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

0

Name: rhawk7938
Date: August 26, 2006 at 10:21:18 Pacific

Reply:

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.

0

Reply:

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

0

Easy inset picture in PPT

Microsoft One Note

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I'm copying this directly from the help file in Excel so I'm not sure if the formating will come out right on this page. If it doesn't then look in the help file and type in "swap colums for rows" It ...

Summary: Excel makes it easy . 1st line u put ur datas titles (beware no blank row between 2 rowsin the title line, i mean a tittle for each column, no blank column inside ur schedule). Below u complete as yo...

Summary: In excel I would like to just type a letter M in a cell and have it finsh like mark. How do I do this? I am making a schedule of people and I have to put the same name in different cells. Thanks ...