SD Motion

SD Motion

Share

Informative Excel Learning Page

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/

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

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.

Want your school to be the top-listed School/college in Muscat?

Click here to claim your Sponsored Listing.

Location

Category

Address


Muscat