19 Excel Shortcuts you NEED to use more [with FREE PDF 📃]

#shortcuts time. Here is a list of 19 Excel shortcuts that are my absolute favourite. If you use Excel for data analysis work, then you must know these.

👉The shortcuts & timestamps ⏱
============================

0:00 - CTRL T - to create a table
1:28 - CTRL Arrow keys ⬆⬇➡⬅ - navigation
2:06 - SHIFT CTROL Arrow keys - Selection
2:33 - CTRL A or CTRL * - Select all
2:51 - F2 - Edit a cell
3:17 - CTRL Enter - Put same value in multiple cells
3:53 - CTRL SHIFT 4 - Apply currency formatting
4:16 - CTRL SHIFT 3 - Format dates in d-mmm-yy
4:31 - F4 - Repeat last action
5:14 - CTRL SHIFT L - Filter on / off
5:51 - CTRL 1 - Format selected thing
7:16 - CTRL E - Flash fill
7:57 - CTRL ; - Current date
8:35 - ALT Enter - New line in a cell
9:08 - CTRL D - Copy down
9:48 - ALT Down arrow ⬇ - In-cell popup
10:47 - CTRL DRAG - to copy selected item(s)
11:27 - WIN . - Emoji keypad in Excel!
12:18 - CTRL F1 - Collapse / expand Ribbon
12:39 - ALT - Show ribbon shortcuts
13:26 - CTRL - (bonus) Delete cells
13:55 - CTRL + (bonus) Add cells

~~~

📑Keyboard Shortcuts Poster for you 👉
=================================

✅✅✅ More shortcuts & top Excel tips videos
========================================

👉 Need to learn Excel❓
====================

Have a beautiful day ❤🌼😀

[sonnie]

As always, thanks for the great video.
F4 and Alt +Down Arrow are very useful. I believe there are many users who don't know about these.
Many often I use Alt + Down arrow on a cell to get a peek on the unique values in the active column.
Unfortunately it will show only text values in the column

[rfdave]

"Chandoo" .... "Candoo" anything. Excellent videos.

[andraspeter]

You are amazing! Thank you for dedicating your time to teach us! 🙏

[teluguworriers]

I never ever listen the as you said sir

Super, I have been following your all classes sir

[hamzaosman]

Thank you sir Chandoo for your lessons, they are very helpful 🙏

[adilfaizanrazvi]

really amazing and time saving for faster analysis with tables

[manikhan]

Chandoo!!! it's awesome and really helpful... Thank you!!!

[entertainmenator]

I am Investment Analyst by profession and your tutorials have helped me a lot with my day to day spreadsheet tasks. Thank You 🙏.

[wayneedmondson]

Hi Chandoo. Great tips and shortcuts! As always, thanks for sharing your knowledge :)) Thumbs up!!

[SanthoshKumar-xyzm]

Wow very nice shortcuts.Thank You very much🙏🙏🙏🙏🙏

[annusharma]

This is the most useful channel, I've ever subscribed for excel tips and tricks

[nauikun]

Thank you sir, every video on this channel is worth of Golds and diamonds.

[kss]

Thank you for the shortcuts. Enjoyed the lesson

[patrickschardt]

Wow I knew a few of these like the table shortcut.

Great shortcut overview

[vijayarjunwadkar]

Thanks a lot Chandoo! These are really super useful shortcuts! 😊👍👌

[MU-bmxm]

Thank you again, another solid video.

[buhaysabungero]

I already knew 17 out of these ahortcuts the f4 is new to me thank you sir.

[sureshachary]

Useful video for all Excel lovers, liked F4 function

[hasleyaar]

Thank you so much dear friend. It is so much helpfull for me. Thank you!!🤗

[philipmuleya]

Thank you so much Chandoo..I always follow up your videos and I've been employed bcoz of Excel skills I've learnt from you