scrolling and markers
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: scrolling and markers

  1. #1
    Guest

    Default

     
    if you have a lot of data (a long,long list) and you need to move up and down the list frequently, can you get to the end of the worksheet without using the scroll bar? I can never get that right and always overshoot or undershoot. Similarly can you mark locations in the sheet so that you can go straight to them without searching/scrolling

    Thanks
    Aditya

    As an aside, could someone explain what a pivot table is?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 07:53, Anonymous wrote:
    if you have a lot of data (a long,long list) and you need to move up and down the list frequently, can you get to the end of the worksheet without using the scroll bar? I can never get that right and always overshoot or undershoot. Similarly can you mark locations in the sheet so that you can go straight to them without searching/scrolling

    Thanks
    Aditya

    As an aside, could someone explain what a pivot table is?
    See the Excel Help topic for "PivotTables: Analyzing data interactively". The table component labels are linked to a descriptive popup text box.

    See the Excel Help topic for "Use shortcut keys in Microsoft Excel". Specifically look at "Move and scroll on a worksheet..."

    You can also use the Edit | Go To... menu command. You can also use the Insert | Name | Define... menu command to create your own named destinations that would be listed in the Name Box just left of the formula bar.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi
    Click in your column, hold down control and press the down arrow to get to the bottom, press the up arrow to get to the top.
    This works if you have an unbroken list.
    regards
    Derek

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
  •  

 

 
DMCA.com