Thursday, August 13, 2015

Select An Excel Data Set Faster with this Shortcut

Microsoft Excel Logo
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.

Control+Shift+End will highlight to the far bottom cell of the data set.

That's it.  No need to reach for that mouse to select data in your Excel spreadsheet.  A couple of quick keyboard commands will let you select your data and be on your way.

Enjoy!


READ MORE

#Microsoft #Excel #dataset #spreadsheet #shortcut #keyboard



No comments: