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.
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
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
Please LIKE and SHARE OneCoolTip.com!
Subscribe to the FREE OneCoolTip Newsletter.
Visit the OneCoolTip YouTube Channel: https://www.youtube.com/@onecooltip
Do you have a Cool Tip or question? Email us at onecooltip.com@gmail.com
One Cool Tip
Cool Tech Tips for a Cooler Life!
#Microsoft #Excel #dataset #spreadsheet #shortcut #keyboard @microsoft365 @MSExcel
#TechTips #TechGuide #OneCoolTip @OneCoolTip
Copyright © 2024 | www.OneCoolTip.com | All Rights Reserved
No comments:
Post a Comment