7

Is there any button combination to jump directly to the last line containing data in Excel rather than scrolling through thousands of lines?

| improve this question | | | | |
  • 2
    Control End will take you to the last cell that has had data in it, then you can Home to the beginning of the line... it remembers deleted data thought... however this seems a bit off topic. – forsvarir May 21 '12 at 13:08
10

You can also try CTRL+Down Arrow key. This will take you to the last non-empty cell in the column. CTRL+Up arrow key will bring you back up to the top.

| improve this answer | | | | |
  • It works with selection too: Select a row and then do Ctrl + Shift + Up/Down Arrow to select everything between the row and the first/last row with data. – brokkr Apr 5 '16 at 13:19
  • Worth noting that "will take you to the last non-empty cell in the column" is not strictly correct. It will take you to the next (NOT last) instance where the cell state of containing data changes. If the current cell has data, it will take you to the next empty cell, not the last non-empty cell in the column. If the current cell has no data, it will take you to the next non-empty cell. – Alex M Apr 16 '19 at 18:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.