Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quick way to get to bottom left of spreadsheet (2000)

    Can you tell me the easiest way to get the cursor to the bottom left hand corner of the spreadsheet rather than keep having to scroll down the screen to get there all the time.
    see screenshot.

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quick way to get to bottom left of spreadsheet (2000)

    CTRL + Home and then CTRL and Down Arrow!
    Regards,
    Rudi

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quick way to get to bottom left of spreadsheet

    Can this be done in macro?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quick way to get to bottom left of spreadsheet (2000)

    Do you mean the lower left corner of the used range of the worksheet? For example:

    Press Ctrl+End to go to the last cell of the used range, then press Home to go to the beginning of the row (if you have applied freeze panes, you'll only go to the beginning of the "unfrozen" part)

    If all cells within the used range in the first column are filled, you can click in any cell in the first column, then press End then down arrow.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Quick way to get to bottom left of spreadsheet

    You could record a macro, but then you'd have to assign the macro to a toolbar button or keyboard shortcut. In this situation, you gain very little.

  6. #6
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quick way to get to bottom left of spreadsheet

    Thanks

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Quick way to get to bottom left of spreadsheet

    Yes it can be done. If you switch on the recorder and record the key stokes (Hans has some good alternatives in his reply), then you can use the macro to get there. These key strokes are fairly generalized as long as there are no gaps (empty rows) within the worksheet.

    PS: You can assign the macro to a button on the toobar fro further quick access if a key stroke is not desired!
    Regards,
    Rudi

  8. #8
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quick way to get to bottom left of spreadsheet

    Thanks for that.

Posting Permissions

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