+ Reply to Thread
Results 1 to 2 of 2

Locking columns

  1. #1
    Registered User
    Join Date
    03-15-2006
    Posts
    1

    Locking columns

    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.

  2. #2
    Trevor Shuttleworth
    Guest

    Re: Locking columns

    Select cell B1 and, from the worksheet menu bar, Choose Window | Freeze
    Panes

    Regards

    Trevor


    "chefatl" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1