Forum Discussion
Applewood
Apr 17, 2022Copper Contributor
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?
6 Replies
Sort By
- Riny_van_EekelenPlatinum Contributor
Applewood Many different ways I believe, but one that I find easiest is to just double-click on the bottom edge of
anythe 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
redand bold above.- ApplewoodCopper Contributor
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_EekelenPlatinum Contributor
Applewood I guess you'll find it here. Scroll down to the section about "navigation".