This would instantly select all the specified cells. Enter the different cells/ranges that you want to select (separated by a comma when selecting multiple ranges).This will place the cursor in the name box
#Define cell for excel in mac how to#
So if you know what cells you want to select, it will be faster to enter the cell reference in the name box and hit the enter key.įor example, suppose you want to select the following cells – A1, C12, D20, K14īelow is how to select these non-adjacent cells using the Name Box: Name Box is right next to the formula bar (on the left of it) and is always visible with the formula bar. In such a case, you can also use the Name Box in Excel to select non-adjacent cells. Sometimes, you need to select specific cells that are scattered and far off. Select Non-Adjacent Cells/Ranges Using the Name Box If you want to select more such ranges, keep repeating the same process. The above steps would select two non-adjacent cells or ranges. This removes the ‘Extend Selection’ mode.
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 kommentar(er)
