Excel tips – Now you can deselect cells from selected ranges

The option is available for Office 365 subscribers

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!

Subscribe now

Categories: General, Excel
Rate this article:

Please login or register to post comments.


Subscribe to our Newsletter

cheat sheet resources

Subscribe to our Newsletter for all the latest cheat sheets and resources.