Throwback: Select An Excel Data Set Faster with this Shortcut
Speed up your Excel workflow! Learn keyboard shortcuts to quickly select data without relying on your mouse.
By Rodger Mansfield, Technology Editor
September 2, 2024 - First published August 13, 2015
You can select data in Excel faster than just using a mouse and dragging the cursor.
Let your fingers do the selecting.
To select an entire data set, click anywhere inside the data set and then press and hold the CONTROL + SHIFT + * keys.
You can also click in the first cell you want to select and press and hold the Control+Shift and then press an arrow key (Left, Right, Up or Down) to select data in a direction.
You can select data in Excel faster than just using a mouse and dragging the cursor.
Let your fingers do the selecting.
To select an entire data set, click anywhere inside the data set and then press and hold the CONTROL + SHIFT + * keys.
You can also click in the first cell you want to select and press and hold the Control+Shift and then press an arrow key (Left, Right, Up or Down) to select data in a direction.