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/
SD Motion
Share
Informative Excel Learning Page
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
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
27/08/2022
Creating Master File Name List in 1 Minute!!! An easy way to create file name list https://youtu.be/I301EvAmG0U
Creating Document Master List in 1 Minute!!! An easy way to create Document Name List 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.
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.
Click here to claim your Sponsored Listing.
Location
Category
Address
Muscat