Save Time and Effort with the CTRL+. Shortcut: The Handy Excel Trick You Need to Know!

Navigating large tables can be time consuming and frustrating, but with this keyboard shortcut you'll save time and effort.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

[soccernflying]

Thank you! I need to incorporate this keyboard shortcut into my repertoire :-) Another one, which I use all the time in this context, is control+backspace

[JJ_TheGreat]

Wow! Another tip I didn't know about!

[heisdolo]

Thank you, this is helpful It saved me some time

[MaddoxIV]

Soothing delivery of very useful info.

[kaesuma]

Hi, you could press CTRL Backspace instead.
Just noticed, someone else has mentioned this.

[Anvar]

With ctrl+a before its very useful. Searched for it a long time! When youre down in a table, and you want to go up a column, but not in a1 which ctrl+home does. Ctrl a and then ctrl . did that.

[sachinrv]

This is new keyboard shortcut which I honestly did not know. Thanks Mynda :) I am a big fan of your Excel content.

[rusektor]

Alternatively, you can press Shift+Tab to go to the previous cell of the range which happens to be bottom right corner cell. 😊

[drohitcoolboy]

I was looking for this for some time. This helps a lot. Thanks

[ahmadxa]

Thank you for sharing that, it's really helpful, another question how did you replace A, B, C, D... with titles when you scroll down.

[siddharthmhaskar]

If possible to share where do you get all these tricks
Thanks for sharing the above method

[deryansyah]

still using ctrl shift up/down for this

[colinchiu]

I've searched for ages for the equivalent shortcut for google sheets. Does it have one ?