Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Trivial shortcut (2003)

    There used to be a shortcut key that would jump to the last column of a data area. I thought it was Ctrl- '.' (period). Any one recall this? Andy.

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

    Re: Trivial shortcut (2003)

    Try End+right-arrow.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trivial shortcut (2003)

    Thanks, although that doesn't reach the last column if there are blank cells. I've discovered that I need to highlight the area and then do Ctrl-period, although this doesn't remain in the same row. Perhaps I was mistaken about this shortcut key.. Andy.

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trivial shortcut (2003)

    <P ID="edit" class=small>(Edited by mbarron on 10-Oct-07 09:10. Removed an unnecessary "or")</P>Ctrl + . will cycle through the corners of the selection in a clockwise direction.

    <table border 1><td>1</td><td> </td><td>2</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td>4</td><td> </td><td>3</td></table>

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

    Re: Trivial shortcut (2003)

    Ctrl+. will move clockwise through the corners of the selected area.
    Ctrl+arrow will move to the last filled cell (without blanks in between) in the direction of the arrow.
    Ctrl+End will move to what Excel considers to be the last cell in the used range of the worksheet. However, it doesn't always keep track of this correctly during a session.

  6. #6
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trivial shortcut (2003)

    Hans:

    <<However, it doesn't always keep track of this correctly during a session.>>

    On that point, is there a way to 'reset' the End cell (in code, or otherwise)?
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

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

    Re: Trivial shortcut (2003)

    There is a way to force Excel to determine the last cell correctly: simply refer to ActiveSheet.UsedRange.Rows.Count or ActiveSheet.UsedRange.Columns.Count. See John Walkenbach Tip#73.

    Example:

    Dim lngLastCol As Long
    lngLastCol = ActiveSheet.UsedRange.Columns.Count

  8. #8
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trivial shortcut (2003)

    Hans:

    Thanks for your reply - and the link to John's routine.

    I've known about a lot of the CTRL and ALT shortcuts for moving around in Excel (CTRL + Arrows, Home, End, PgUp, PgDn, Tab, etc) but while playing around with this today I discovered two new ones (new to me, that is - you probably know them) so I thought I would share with others.

    HOME + END takes you to the bottom-right cell on screen and END + HOME takes you to the top-left cell on screen.

    Regards,
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  9. #9
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Trivial shortcut (2003)

    How about Ctrl-Shift-Right arrow? Highlights the range to the last used cell in the selected row (or top row if you have selected multiple rows).

    (FWIW Ctrl+* (asterisk) selects the block of populated cells surrrounding the selected cells, but I don't think that is quite what you are looking for.)
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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