Premium Only Content

Excel Hidden Shortcut to Select Data Column including Blanks
12 March 2020 Excel Hacks: Tips & Tricks
The first 500 people who click the link will get 2 free months of Skillshare Premium: https://skl.sh/xelplus8
You probably know the quickest way to select a column of data in Excel is with the shortcut CTRL + Shift + ⯆. But what do you do if that column includes blank cells and you'd like to highlight the entire column of data? CTRL + Shift + down arrow key will stop the moment it comes across a blank cell.
Check out this video for the update: https://youtu.be/zo4l-G3Qgyk
This is often a very annoying problem especially if it's a large data set or there are a lot of blank cells. In this video I'm going to show you a trick which EASILY gets this done.
A shortcut which is often used is CTRL + End which jumps to the end of the data set. However, that may not always work if there is some additional input in other cells outside of the data set.
Here's the Excel Keyboard Shortcut(s) to Select Column with Blank Cells:
A better alternative is to use the Name Box in Excel. Just put in the range you want and use a random, very high "TO" value where you know you will not have any data anymore, e.g. B1:B10000. Press Enter. This will highlight the entire range. Then use the short cut CTRL + SHIFT + ⯅. This will highlight the data set including the blank cells.
The same thing can also be done with just the keyboard, no mouse. Press CTRL + G to get to the Name Manager. In the reference field type in the range, e.g. B1:B10000 and press Enter. Then use the short cut CTRL + SHIFT + ⯅. This will highlight the data set including the blank cells.
Detailed article: https://www.xelplus.com/excel-shortcut-select-column-with-blanks
This video was sponsored by Skillshare.
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
-
LIVE
Dr Disrespect
5 hours ago🔴LIVE - DR DISRESPECT - ARENA BREAKOUT: INFINITE - STORM EVENT
2,547 watching -
LIVE
Barry Cunningham
5 hours agoPRESIDENT TRUMP SPEAKS ON JAMES COMEY INDICTMENT! MORE TO COME! DELICIOUS LIBERAL MELTDOWNS!
2,178 watching -
25:59
Simply Bitcoin
1 day ago $0.63 earnedMichael Saylor Reveals $81T Bitcoin Plan to Cancel National Debt?!
9.44K5 -
1:33:51
Steve-O's Wild Ride! Podcast
1 day ago $0.92 earnedJohn C. Reilly's Surprising Connection To Jackass (And Beef With Weeman!)
22.9K5 -
LIVE
StoneMountain64
3 hours agoBattlefield 6 News and Extraction Gaming
80 watching -
2:13:30
Side Scrollers Podcast
6 hours agoUK Introduces MANDATORY Digital ID + Dallas ICE Shooting BLAMED on Gaming + More | Side Scrollers
85.8K7 -
1:54:17
The Charlie Kirk Show
4 hours agoCharlie's Last Trip + What's Next + AMA | Erika Kirk, Mikey McCoy | 9.26.2025
272K234 -
1:02:53
The Quartering
3 hours agoMAGA Kid Kidnapped, Hasan Piker Meltdown, Vivek Fights For Alex Jones & More
129K44 -
32:49
Simply Bitcoin
1 day ago $1.39 earnedBitcoin Crucible w/ Alex Stanczyk | EP 1
36.4K -
1:57:37
Tucker Carlson
3 hours agoCharlie Sheen’s Craziest Hollywood Stories and Why He Refuses to Believe the Official Story of 9/11
60.2K58