Select Table Column Range with Blank Cells - Excel

Опубликовано: 11 Март 2026
на канале: Doug H
1,865
35

To select a table column range that has blank cells in unexpected places where you WANT to select the whole column with the data may be something that you're used to doing with the CTRL+SHIFT+Down Arrow key. But those pesky blank cells get in the way. You might think you'll have to select the whole column (click column header) to do this, but no it's really quite simple. Here's an Excel #shorts video to show you how.

🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to
https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
   • Convert Table in a PDF File to Excel  
~-~~-~~~-~~-~