Results 1 to 5 of 5
  1. #1
    New Lounger Bigshrimp60's Avatar
    Join Date
    Mar 2011
    Posts
    22
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Shortcut key to get to last cell with text

    Greetings!
    I have a pretty large excel 2007 spreadsheet in which I am always adding data. Is there a shortcut key that will take me to the last cell with data in it. I tried Ctrl+End but that takes me quite a few pages past my last cell with data. I appreaciate any help that comes my way.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Control- End takes you to where excel believes is the last cell. Do you have formatting that extends to other columns or rows?

    You can try deleteing columns and rows past the actual last cell and then save the file, close excel and restart and the last cell will be reset and should work again.

    Steve

  3. #3
    New Lounger Bigshrimp60's Avatar
    Join Date
    Mar 2011
    Posts
    22
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks for the response. I did delete columns and rows past my last row with text in it, but Ctrl + End takes me to row 722. My last cell with text in it is 305. Maybe I need a macro that will find and then go to the last row of text.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Try some of the techniques at http://www.ozgrid.com/VBA/ExcelRanges.htm

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Mar 2010
    Location
    Tampa, FL, USA
    Posts
    114
    Thanks
    11
    Thanked 10 Times in 9 Posts
    Like Steve said, see the information at the OzGrid page. To summarize:

    Because formated empty cells will "fool" Excel's ctrl-End key, you'll need to use a VBA routine to locate the actual last used cell in your spreadsheet. This routine will put the cursor on the last used cell:
    Code:
    Public Sub LastUsedCell()
    
    Cells.Find(What:="*", After:=[A1], SearchDirection:=xlPrevious).Select
    
    End Sub
    Assign this macro to a hot key (e.g. ctrl-shift-L) and the cursor will be on the last cell when the hot key is pressed.
    Last edited by pjustice57; 2011-05-04 at 12:23. Reason: Answer already posted. Expanded with a ready-built routine.
    PJ in FL

  6. The Following User Says Thank You to pjustice57 For This Useful Post:

    Bigshrimp60 (2011-05-04)

Posting Permissions

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