In that case we will use the below given steps for selecting multiple cells
We can quickly highlight the cells but only when these cells are adjacent cells or cells that are located beside each other.īut in case we required to select any non-adjacent cells which are not beside each other.
The most common and basic way to select these adjacent cells ranges in Microsoft Excel is using mouse drag select method.
In this article we will learn how to select non adjacent cells in Excel?Īt times you may require to select multiple cells in a range or different ranges in Microsoft Excel, for deleting the data or applying a format painter for font color or border.
