![]() |
Freeze columns
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 |
Freeze columns
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! -------------------- (Ms-Exl-Learner) -------------------- "Nydia" wrote: 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 |
Freeze columns
Hi Nydia
You can either try freeze panes options or use the Spit option. XL07: ViewSplit/Freeze Panes XL03: WindowSplit/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 --------------- Jacob Skaria "Nydia" wrote: 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 |
All times are GMT +1. The time now is 11:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com