Freeze columns

N

Nydia

I want to freeze column B so when I scroll to the end of my spreadsheet I can
still see what is typed in Column B
 
M

Ms-Exl-Learner

Try this...

Just place the cursor in the C2 cell ALT+W+F to do freeze in 2003, for 2007
press ALT+W+F and enter.

If you dont want the 1st row heading then place the cursor in c1 cell and try.

If this post helps, Click yes!
 
J

Jacob Skaria

Hi Nydia

You can either try freeze panes options or use the Spit option.
XL07: View>Split/Freeze Panes
XL03: Window>Split/Freeze Panes

(If you use the split option you can drag the horizontal split to top so as
to have the vertical one alone..)

If this post helps click Yes
 
Top