Select An Excel Data Set Faster with this Shortcut

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


Originally published at www.onecooltip.com on August 23, 2015.

Show your support

Clapping shows how much you appreciated www.OneCoolTip.com’s story.