SD Motion

Here's a draft LinkedIn post on your suggested topic:

Ever get frustrated using shortcut keys like SHIFT + CTRL + ↓ in Excel, only to have it stop at a blank row? 😣 I ran into this recently and wanted to share a quick tip.

The SHIFT + CTRL + ↓ shortcut is super handy for selecting an entire column in Excel. But it stops when it hits a blank cell, which can mess up your selection. 🚫🤯

Here's a simple fix:

- CTRL + SPACE to select the entire column
- Then use SHIFT + CTRL + ⬆️
- Then CTRL + .
- Finally SHIFT + CTRL + ↓

This will ignore any blank rows and select everything you want. 🎯 No more shortcut snafus!

Let me know if this helps simplify your Excel shortcut struggles. I'm always looking for ways to make Excel less excel-lent at wasting our time. 😆 Share your favorite shortcuts below too! www.YouTube.com/