Forum Discussion

Copper Contributor

Apr 17, 2022

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

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?

excel

Riny_van_Eekelen

Platinum Contributor

Apr 17, 2022

Applewood Many different ways I believe, but one that I find easiest is to just double-click on the bottom edge of ~~any~~ 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.

Edit: See changes in ~~red~~ and bold above.

Applewood
Copper Contributor
Apr 17, 2022
Riny_van_Eekelen Doesn't seem to work. I do not know how to double click on the Mac. 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. I am definitely missing something. Appreciate your efforts to help. Perhaps you could list some of the other ways you mentioned?
- Riny_van_Eekelen
  Platinum Contributor
  Apr 17, 2022
  Applewood I guess you'll find it here. Scroll down to the section about "navigation".
  https://www.myonlinetraininghub.com/excel-shortcuts
  - Applewood
    Copper Contributor
    Apr 17, 2022
    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 ...