SD Motion

04/10/2023

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/

05/12/2022

How to alighn text centre without merging cell ranges in Excel
For more daily Excel Tips follow me on YouTube:
https://youtube.com/shorts/GAwRSbvyMgo

23/10/2022

DO you know how to create Data entry form Faster? Check this out then
For more Advanced Excel Tutorial Visit and Subscribe to My YouTube channel
https://www.youtube.com/shorts/poL1-dNjutw

Send a message to learn more

27/08/2022

Creating Master File Name List in 1 Minute!!! An easy way to create file name list https://youtu.be/I301EvAmG0U

Create Masterlist of Document names in one minute!Similarly it can be copy to the excel file too.

22/08/2022

FREE Excel UNIQUE function for any Excel Version! UNIQUE Function Add-Ins.

In this video, I have discussed how to install the Excel UNIQUE function for Excel 365 Non Subscription versions. ✅ Get your free Add-Ins file here [Hope you...

22/06/2022

Hi Friends!, this short video is shown how to create conditional formatting with the control box. you may use option buttons or various methods to do the same. Hope you will like this video. See the link in the first comment.