+ Reply to Thread
Results 1 to 3 of 3

Static Column

  1. #1
    Registered User
    Join Date
    10-18-2006
    Posts
    2

    Smile Static Column

    Hi

    Can somebody help me? I want to set a column at the left of my workbook that will remain in view regardless of which column I'm working on. To explain, I have a series of jobs down the left of the page and hours worked on each day by day to the right. When I get to the 10th column the 1st one has been lost to the left of the screen and it is difficult to see which job I'm adding hours too. Any help would be greatly appreciated.

    Thanks

    Andy

  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,

    Have you tried Windows > Freeze Panes

    Select Cell B1 and freeze panes

    VBA Noob

  3. #3
    Registered User
    Join Date
    10-18-2006
    Posts
    2

    Smile

    Thanks for that. It is exactly what I need

+ 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