How do I lock a column so it doesn't move when I scroll across?
 

I'm trying to lock a column so that it doesn't move when I scroll across my
Excel spreadsheet, is there a way I can do that or no? Please let me know.

How do I lock a column so it doesn't move when I scroll across?
 

Select cell B1
WindowFreeze Panes
If you had selected B2 instead, it would keep Row 1 in sight as well


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Lanette" wrote in message ...
| I'm trying to lock a column so that it doesn't move when I scroll across my
| Excel spreadsheet, is there a way I can do that or no? Please let me know.