How do I get to last cell in a COLUMN with data quickly?

Question

I have a very large spreadsheet and the first column is dates. Other column cells may have data or not in different places. How do I quickly go to the last cell in a column that has data in it?

riny_van_eekelen · Answer

Applewood&nbsp;Many different ways I believe, but one that I find easiest is to just double-click on the bottom edge of any&nbsp;the active cell in that column. Likewise, you may double-click on the top edge to jump back to the top. Clicking on the left and right edges has a similar effect. It will jump in the direction you are clicking.&nbsp;Edit: See changes in red and bold above.

applewood · Answer

Riny_van_Eekelen&nbsp; &nbsp;Doesn't seem to work. &nbsp;I do not know how to double click on the Mac. &nbsp; &nbsp; When I double click (quickly tapping twice). I can't really tell if it is on the bottom of the cell but it only goes to the next cell. &nbsp;I am definitely missing something. Appreciate your efforts to help. &nbsp;Perhaps you could list some of the other ways you mentioned?

riny_van_eekelen · Answer

Applewood&nbsp;I guess you'll find it here. Scroll down to the section about "navigation".https://www.myonlinetraininghub.com/excel-shortcuts&nbsp;

applewood · Answer

Thank you for your efforts.. The keys are not necessarily for a Mac. Also their is one that navigates to the last cell with data supposedly but not the last one in a column with data. ... unless I further an missing something, I'll keep looking.. I can't believe there isn't something ...

riny_van_eekelen · Answer

Applewood&nbsp;For the Mac specifically, try cmd and arrow down.&nbsp;Edited my first response as it may have been unclear. I meant to say that you have to click on the edge of the active cell, not just any cell.

Forum Discussion

How do I get to last cell in a COLUMN with data quickly?

6 Replies

Resources