In this post you'll discover how to select blocks of content instead of going cell by cell and some some fast ways to get around a worksheet.
1. Moving around a worksheet
2. Navigating directly to a chosen cell
To go directly to a cell (only really useful in large spreadsheets)
1. Press Ctrl G or press F5.
2. Specify the worksheet name and cell reference (e.g. B2).
![[E1] 02 - 08 navigate directly cell Navigating directly to a chosen cell](https://d1pzfp4ixszkr4.cloudfront.net/img/2020/03/01094932/E1-02-08-navigate-directly-cell.png)
RELATED POST:
How to resize, insert or delete row(s) and column(s)
3. Selecting a cell
1. Click in the cell.
2. To select other non-adjacent cells at the same time, hold down the Ctrl key and click on the other cells.
4. Selecting a range of cells
![[E1] 02 - 02 selecting arange of cells](https://d1pzfp4ixszkr4.cloudfront.net/img/2020/03/01094930/E1-02-02-selecting-arange-of-cells.png)
5. Selecting row(s) or column(s)
![[E1] 02 - 03 selecting row column Selecting a row or column](https://d1pzfp4ixszkr4.cloudfront.net/img/2020/03/01094930/E1-02-03-selecting-row-column.png)
6. Selecting the entire worksheet
To select every cell on the sheet:
1. Click the grey block between the ‘A’ column label and the ‘1’ row label.
2. Alternatively, press Ctrl A.
![[E1] 02 - 07 selecting the entire worksheet Selecting the entire worksheet](https://d1pzfp4ixszkr4.cloudfront.net/img/2020/03/01094931/E1-02-07-selecting-the-entire-worksheet.png)
7. Key Takeaways
Please feel free to post any questions you have into the comments below. And before you leave this page, I want to give you one quick little action item!
ACTION ITEM: Comment below with ONE thing you picked up from this post and share how it has helped, or will help, you. It's good to share your successes because it encourages others and provides an instant boost.
Enjoy the rest of your day!


About the author
Jason Morrell
Jason loves to simplify the hard stuff, cut the fluff and share what actually works. Things that make a difference. Things that slash hours from your daily work tasks. He runs a software training business in Queensland, Australia, lives on the Gold Coast with his wife and 4 kids and often talks about himself in the third person!
SHARE