How to quickly jump to a specific cell (A1) in Excel?
If there is a huge worksheet, while you want to go to a specific cell, for instance, cell A1, generally, you may scroll the sheet until the cell A1 displays which may cost much needless time. In this article, I introduce the tricks on quickly jumping to a specific cell in Excel.
If you want to quickly jump to cell A1 from anywhere of the sheet, you just need to hold Ctrl key, and press Home, then the cursor jumps to the cell A1 at once.
If you want to jump to a specific cell, for instance, C14, you can apply go to the Name box which is left to the formula bar, and type the cell reference which you want to jump to, and press Enter key.
Also, you can apply the Go To function to quickly jump to a specific cell.
Press F5 key to enable the Go To dialog, then in the Reference textbox, type the cell reference you want to jump to, then click OK, then the cursor will jump to the cell you specify.
Select Cells/Rows/Columns with one or two criteria in Excel
|The select Specific Cells of Kutools for Excel can quicky select all cells or rows or columns in a range based on one criterion or two criterion. Click for 30 days free trial!|
|Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.|
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!