I have a spreadsheet that I want to lock column A so when I scroll to the right the data will scroll, but column A stays put.
I have a spreadsheet that I want to lock column A so when I scroll to the right the data will scroll, but column A stays put.
Select cell B1 and, from the worksheet menu bar, Choose Window | Freeze
Panes
Regards
Trevor
"chefatl" <chefatl.24qk6n_1142467804.1806@excelforum-nospam.com> wrote in
message news:chefatl.24qk6n_1142467804.1806@excelforum-nospam.com...
>
> I have a spreadsheet that I want to lock column A so when I scroll to
> the right the data will scroll, but column A stays put.
>
>
> --
> chefatl
> ------------------------------------------------------------------------
> chefatl's Profile:
> http://www.excelforum.com/member.php...o&userid=32501
> View this thread: http://www.excelforum.com/showthread...hreadid=522909
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks