The ability to quickly select data in Excel is very useful and can save us time.
[ Video tutorial produced by Activia Training and purchased by ZandaX ]
To highlight your entire database use Ctrl + A to select All. Ctrl + Home to return to cell A1.
Use Ctrl + Shift + down arrow to select a range of data in a column and Ctrl + Shift + Right arrow to select a range of data in a row.
Use Ctrl + Spacebar to select an entire column and Shift + Spacebar to select an entire row.
Ctrl and + will insert a row or column and Ctrl and – will delete a row or column.
Select multiple cells using Ctrl and clicking on the required cells with the mouse to select a non-contiguous (non-continuous) range. Use Shift to click on a cell to select a contiguous (continuous) range
Use Ctrl and the mouse scroll wheel to zoom in and out of the spreadsheet.
So a sequence to select, copy and paste data would be:
Ctrl + A; Ctrl + C then Ctrl + V to paste. Or Ctrl + Alt + V to use Paste Special.
Avoid using Ctrl + A when in an empty cell as this will select the entire sheet (16,384 Columns and 1,048,576 Rows). This won't increase the size of your workbook but may slow down your machine.
Make sure your active cell is inside the database you want to select and then press Ctrl + A to select the entire database. Databases are separated by blank columns or rows allowing us to have multiple databases inside the current worksheet.
Want Better Excel Skills?
We have online courses with full 12-months' access. RRP from $49 limited time offer just $12.00
Get a solid foundation in Project software to create solid, resilient project plans.
You don't need prior experience with Project: just be able to use a PC with Microsoft Windows.
Microsoft Project Advanced
The Advanced course takes you to a level that will put you in complete control of your projects.
You should, of course, be fully conversant with the skills and concepts taught in the Introduction course.
Become a Visio master with our two intensive but very easy-to-follow CPD certified Microsoft Visio courses.