June 7


Selecting cells and moving around an Excel worksheet

By Sharyn Baines

June 7, 2018

Entering Data

If you are new to Excel, before you start entering data it’s a good idea to become familiar with how to select cells using the keyboard and the mouse.

Using the cell selector

The cell selector is the heavy outlined rectangle that indicates the current working position (selected cell or cells).

This can easily be moved simply by clicking a cell. Just be sure that the mouse pointer is displayed as a fat white cross before you click.

Excel big fat white cross

You can also move the cell selector using the directional arrow keys on your keyboard.

Excel keyboard arrow keys

You will notice the row number and column letter are highlighted to indicate the current position of the cell selector. In the example below cell A1 is currently the selected cell.

Excel selecting a cell

The cell selector can be extended to cover multiple cells by clicking and dragging the mouse pointer across the selection (just make sure the mouse pointer is a fat white cross before clicking and dragging) or by holding down SHIFT on your keyboard and pressing your arrow keys in the direction you wish to move.

This is called ‘selecting’.

To select more than one range, select a range as normal and then press and hold down CTRL on your keyboard while selecting additional ranges.

We do this so that we can update all of the selected cells at the same time. For example, apply a colour to a range or delete data from multiple cells.

There are number of keyboard shortcuts that you can teach yourself so that you can whiz around the worksheet quickly. I’ve outlined these for you in my post Excel keyboard shortcuts for selecting and moving around a worksheet.


If you found this post helpful please ‘Like’ us!

If you enjoyed this you may also enjoy


Sharyn Baines

About the author

Sharyn is an expert trainer. She became the first certified Microsoft® MOUS Authorised Instructor in New Zealand. She is endorsed by Microsoft® as a qualified Microsoft® Office Specialist and has more than 20 years of experience in the training industry, developing and delivering technology training workshops. Her approach to taking the “techie-speak” out of technology training has placed her as a preferred supplier to many of New Zealand’s leading organisations.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

JOIN FREE! 'Excel at Work Insiders Group' for free tutorials, mini-courses, videos and blogs!