•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Jumping down to visible cells
Our take
If you're working with large datasets in a spreadsheet and need to navigate efficiently, you might wonder how to jump to the last visible cell in a specific column. In your case, starting from cell B1 and wanting to reach B500,000—bypassing the empty cells in column B—can be tricky. Instead of the usual Control + Down Arrow, you'll want to explore alternative methods that allow you to navigate directly to the last relevant cell, enhancing your workflow and productivity.
Probably an easy question. Let’s say I have data in every cell from A1:A500,000and C1:C500,000, column b completely blank. Stating on cell B1, is there a way I can jump to B500,000instead of the very bottom of the sheet (which would happen if I used control + down arrow)?
Edit: for clarity
[link] [comments]
Read on the original site
Open the publisher's page for the full experience