How to quickly jump to next cell with data in Excel?
If there are some empty cells in a list, and how can you quickly jump to the next cell which with data in Excel? In this article, I introduce the easy trick on jumping to next non-blank cell.
Jump to next cell with data by shortcuts
Jump to next cell with data by shortcuts
To jump to the next non-blank cell, you just need to hold Ctrl key, and press Down Arrow key 
to go to the next non-empty cell.
For example, in the Column A, Cell A3, Range A7:A9 are blank. Now the Cell A1 is selected, the cursor will jump to the Cell A2 when you press the Ctrl + Down keys for the first time, and jump to Cell A4 while you press the Ctrl + Down keys.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
