+ Reply to Thread
Results 1 to 3 of 3

Keyboard shortcut - Moving Cursor

  1. #1
    Registered User
    Join Date
    03-12-2007
    Posts
    4

    Keyboard shortcut - Moving Cursor

    Hey, is there a command within excel that will allow me to push 2 bottens or w/e and jump the the nearest open space, like lets say a1, threw a5 is filled, is there a way to simply push something and it will take you to a6 or w/e?

  2. #2
    Registered User
    Join Date
    08-30-2006
    Posts
    40
    Sure, if your cursor is on A1-A4 you can press ctrl+down to jump to A5 which is the last filled cell in that column. If your cursor is past A5 (in a blank cell somewhere) you can press ctrl+up to go up to the first blank space, which would be A6 in this example. You can also move left or right along the row in the same way if A1, B1, C1, etc are filled and you need to jump to the first blank cell in row 1.

    Ctrl+End will take you to the last populated cell in the document, furthest down AND right (A5 in your example). Ctrl+Home will take you to the 1st populated cell in the document, furthest up and left (A1 in your example).

  3. #3
    Registered User
    Join Date
    03-12-2007
    Posts
    4
    thank you, that is what i needed.. have a good one

    Kyle

+ 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