Select cells quickly and easily in Excel using the keyboard instead of the mouse
Once you get used to using Excel, you can find that using the mouse to select data in your spreadsheet is somewhat slow and time consuming. Here's a quick technique for selecting cells in Excel.
Move the active cell (that's the cell currently selected) to the start of the range of cells you want to select. Then, hold the SHIFT key down and use the arrow keys on the keyboard to move in the direction of the last cell in the range of cells you want to select. Notice that, as long as you are holding down the SHIFT key while pressing the arrow keys, all the cells from teh starting point to the current point are selected. Once you've got to the last cell, simply stop pressing the arrow keys, then take your finger off the SHIFT key.
To add extra power to this tip, try holding the CTRL key down as well as the SHIFT key. You'll find that the active cell jumps across empty sections of the spreadsheet, or across non-empty sections. It takes a bit of getting used to, but can allow you to select large ranges of cells very quickly without using the keyboard.
About Us
Fiveminutelessons.com is a website dedicated to providing free training on a range of subjects. We're starting with lessons on Microsoft Word, Excel and PowerPoint but have plans to add other subjects over time such as Adobe Photoshop and Microsoft Project as well as non-software subjects.
We're based in Tauranga, New Zealand but have years of experience in the UK, USA and Ireland working in the training industry with a range of clients from small businesses to blue chip corporates.
Commercial Services
As well as the free training you get at www.fiveminutelessons.com, we also offer a range of commercial services to help you with your training and online learning requirements including:
- Private labelling
- Courseware development
- e-learning development
- Corporate subscriptions
- Learning consultancy services
- Documentation and user guide development
- Development of innovative corporate learning environments
We offer these services for Microsoft Word, Excel and PowerPoint, as well as a range of other popular software applications. We can also assist with documentation and courseware development for custom or in-house software packages.
Contact us now to find out more about our learning consultancy and courseware development services