+ Reply to Thread
Results 1 to 2 of 2

can I fix 1 column & scroll across others?

  1. #1
    Registered User
    Join Date
    07-13-2006
    Posts
    1

    Question can I fix 1 column & scroll across others?

    I'm trying to set up a sheet where the first column is text, and the subsequent columns are calculations. There are 52 calculations columns. I'd like to fix the text column in place so it is always the left-most column, while still being able to scroll through the other columns - that way I have a label to reference instead of trying to follow row 12 back to column A to see what the row represents. Can you tell me how to do this?

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    You could try selecting cell cell B2 and then selecting Windows > Freeze Panes

    VBA Noob

+ 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