Results 1 to 4 of 4

How to make a column stay visible on screen

This is a discussion on How to make a column stay visible on screen within the Excel Questions forums, part of the Question Forums category; Firstly thanks to all who hepled me last time. Now, how can I make a column stay visible when I ...

  1. #1
    New Member
    Join Date
    Nov 2002
    Posts
    27

    Default How to make a column stay visible on screen

    Firstly thanks to all who hepled me last time.

    Now, how can I make a column stay visible when I scroll off the page

    I want column A to always be visible how ever far to the right I scroll

    Cheers

  2. #2
    MrExcel MVP fairwinds's Avatar
    Join Date
    May 2003
    Posts
    8,634

    Default Re: How to make a column stay visible on screen

    Hi,

    Select column B

    then Window - Freeze panes
    "Fair Winds and Following Seas"

  3. #3
    Board Regular
    Join Date
    Jan 2003
    Posts
    273

    Default Re: How to make a column stay visible on screen

    Hi go to window and freeze panes (make sure you select cell B1)


  4. #4
    Board Regular
    Join Date
    Aug 2003
    Location
    Boston
    Posts
    174

    Default Re: How to make a column stay visible on screen

    WINDOW - FREEZE PANES

    Put the cursor in the first cell down and to the right of the region you want to freeze.

    If you only want to freeze column A, you would select cell B1, then use the freeze command

    If you wanted to view row 1 and columns A & B, you would select the cell C2 and then use the freeze command.

    (edit) marstonk - just beat me too it!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com