One of the main requests from the Excel community was finally addressed by Microsoft. Now users of Office 365 can deselect cells or a range from a current selection. The feature works either for PC and Mac. Users who deal with large amount of data are the ones how most benefit of the feature.
How to unselect a cell from a selection
With the whole area selected, you hold down the CTRL (or Command on mac) key and click on the cells you want to deselect. To unselect a range of selected cells hold down the CTRL (or Command for Mac) key and drag the range you want to deselect, starting from within a selected range. As you can see in the image below.
How to multi select cells or ranges
This feature as available before, it means that you can still use the CTRL (or Command on Mac) key to click on an unselected cell to select it. The new thing is that you can select an additional range simple use the CTRL (or Command on Mac), starting on an unselected cell and drag the mouse to select the range, as the image below is showing.
*This article is based on the information provided by the Microsoft blog which you can access here.
Master your Excel skills
Being Microsoft Office skilled can be handy in the daily basis, it can save your time and make your activities more productive. At New Horizons Ireland we frequently run a wide range of Microsoft Office classes either on our premises or online. Check out below our classes.
We also provide a wide range of Technical courses, such as Microsoft Azure, Windows Server, CompTIA, Cisco and more.
Complimentary Office Skills Assessment
Looking to find out what level of Excel, Word or PowerPoint you need to enrol in or simply looking to find out your level of expertise in Office? Well click the link below and take the test no, completely obligation free.
Free skills assessments for:
Subscribe for more!
Like our tips and tricks? Like to get your hands our latest keyboard shortcut cheat sheets? Or want to make sure you never miss our webinars and resources? Well subscribe to our Newsletter now!