how to make a pie chart in excel with non adjacent ranges

And also you can follow us on Twitter and Facebook. If you liked our blogs, share it with your friends on Facebook. Once all the require range has been selected press shift and F8 key to stop and add to selection option.For adding another range within the above range go to another first cell of another range and press F8 key and select the range, after selecting the range press shift + F8.Once the range has been selected using F8 and arrow key, press shift and F8 key on highlighted cells and the range will be locked.Add to selection, shift + F8 :- This option would add the range into the selected range :.To stop the extended selection mode press F8 again.Now you can navigate within the range wherever you want to select using the arrow keys and cells would also get selected.Go to the first cell which is require to be selected and press F8 it would activate extended mode (see the status bar left bottom side) and the selected cell would be locked.

Extended selection mode (F8 Key) :- This option locks the starting cell of require range and allows the further range to be selected:.In case you release the ctrl key very soon and you wish to select more cells all you need to do is simply press and hold the ctrl key ( earlier cells must be highlighted) and start clicking on the additional cells again.Be careful while selecting cells with using ctrl key, unwanted selection can’t be deselected.Note: Don’t click you mouse pointer anywhere else once you release the ctrl key else you will lose all of the highlighted cells.Now click on rest of the cells which you want select without releasing ctrl key and as the required cells are selected release the ctrl key.Press and hold ctrl key on the keyboard.Go to first cell which you want to select, click mouse pointer and make it an active cell.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.

How to make a pie chart in excel with non adjacent ranges