Back to library
Microsoft Excel

Add non-adjacent cell or range to selection

Press Shift+F8 to add a non-adjacent cell or range to an existing selection using arrow keys.

Shift + F8

When to use it

When you need to select multiple non-contiguous cells or ranges without using the mouse.

Pro tip

After pressing Shift+F8, use arrow keys to move to the desired cell or range, then press Shift+F8 again to add it.

Esc F1 F2 F3 F4
F5 F6 F7 F8
F9 F10 F11 F12
PrtSc Scroll Pause
` ~ 1 ! 2 @ 3 # 4 $ 5 % 6 ^ 7 & 8 * 9 ( 0 ) - _ = +
Ins Home PgUp
Tab Q W E R T Y U I O P [ { ] } \ |
Del End PgDn
Caps A S D F G H J K L ; : ' " Enter
Shift Z X C V B N M , < . > / ? Shift
Ctrl Win Alt Space Fn Alt Ctrl

More from Microsoft Excel View all