If you want to quickly move to the last cell of your table/data you can press CTRL + ↔ ↕.
If you want to quickly highlight up to the last cell of your table/data you can press CTRL + SHIFT + ↔ ↕.
Helpful Resource:
CTRL + SHIFT + ARROWS: Move/Highlight Cells
About The Author
Sometimes ctrl + shift + right arrow (or down arrow) highlights up to the last cell in my row or my column of my data, but sometimes it highlights all the way to the very last row 1048576 or very last column way outside my data.
How do I get it to stop at the end of my data? Thank you!
-
Hi Lorrie,
One quick tip, is you can convert your data into a Table (press Ctrl+T).
Kind Regards,
Bryan
