Shift is very useful when using keyboard shortcuts but can often be underrated. When moving around the spreadsheet you may use the mouse or your keyboard or a combination of both. Shift will work differently when using your mouse or your keyboard.
[ Video tutorial produced by Activia Training and purchased by ZandaX ]
Open a blank workbook on Excel and press the TAB key and your active cell should move to the column on the right. Hold in Shift and then press the TAB key and it reverses direction moving your active cell to the column on the left. You can also use this shortcut when tabbing through options in a dialogue box.
Press the Enter key and your active cell should move to the row below. Hold in Shift and then press the Enter key and it reverses direction moving your active cell to the row above.
Using Shift and the arrow keys will select cells and using Shift when clicking on cells will select a contiguous cell range.
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.