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?
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?
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).
thank you, that is what i needed.. have a good one
Kyle
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks