+ Reply to Thread
Results 1 to 4 of 4

move to bottom of worksheet

  1. #1
    Registered User
    Join Date
    08-15-2008
    Location
    denver
    Posts
    68

    Question move to bottom of worksheet

    How can I, in a few short keystrokes, move to the last content row of a worksheet. Pressing [end][down] just takes me to the next blank cell. If I go to a blank column, I can go all the way to row 1 million+, then move left or right, then [end][up], but that particilar column may not have an entry in the last row.

    Years ago, SuperCalc (not too many people remember that one) had such a function.

    I'm using Excel 2007.

    Thanks

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    I see what you mean.
    This is probably too complicated but...
    Goto (Ctrl+G)
    Select: Special and then Last visible cell
    It will move to bottom, right corner in the active area
    Record it as an Macro.

    You could also use an Autofilter to deselect blank cells. Then use End+Down key.
    I think the only other option is to use VBA

    HTH
    Ola

  3. #3
    Forum Contributor SOS's Avatar
    Join Date
    01-26-2004
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    327
    Hi jmhultin,

    Why not Ctrl+End (which takes you to the last used cell) and then Home which will take you to Col A of that row
    Hope this helps

    Seamus

  4. #4
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    Nice, thanks.
    I should study those shortcuts.
    //Ola

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1