Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Multiple freezes

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Australia
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Trying to create a simple database within a sheet with a scroll box in the centre of the screen that views say five records of the database. Can freeze the top part of the sheet for all the headings etc but want to do the same below the displayed data and display some summary calculations there. Can this be done.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mhmmm... how about creating two windows ? you can arrange them to "look" like the bottom is always visible..
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    New Member
    Join Date
    May 2002
    Location
    Australia
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes...Thanks......but I was hoping that I could do this thing in the middle of the screen, mainly for visual presentation I suppose. Then I could dress up all sorts of calculations above and below and even on the sides.

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could always setup a separate sheet or a separate area on the same sheet to look as you wish by refering to the data you want to present.
    Just use borders, formatting, ect...
    Would not be difficult.
    Tom

Some videos you may like

User Tag List

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
  •