Hold the Shift key and press the F8 key.Use the arrow keys to make the selection.Use the arrow keys to place the cursor on the next cell that you want to include in the selection.This removes the ‘Extend Selection’ mode and changes it to ‘Add or Remove Selection’ Since you’re in the Extend Selection mode, this will keep a selection of all the adjacent cells This will put your system in the ‘Extend Selection’ mode. Place the cursor on the first cell that you want to select.While the best way is to use the above method (using a combination of keyboard and mouse), if you want to only use the keyboard to select non-adjacent cells, you can do that as well.īelow are the steps to select non-adjacent cells using the keyboard: Select Non-Adjacent Cells Using the Keyboard Only In case you want to select more than two ranges of non-adjacent cells, keep the control key pressed, and keep making the selections. This would select two non-contiguous range of cells. Place the cursor on the second cell/range that you want to select.At this point, you would have a selection. Left-click on the mouse and drag to make the selection. Click on the first cell that you want to be selected.The easiest way to select non-adjacent ranges is by using the mouse (along with the keyboard).īelow is how to select two non-adjacent range of cells: Select Non-Adjacent Cells Using the Mouse
0 Comments
Leave a Reply. |