TOP 10 Excel Shortcuts in 1 Minute #shorts

Use ctrl + back slach for row difference.

I am already using this tricks regularly since last 3 years.

I knew most of them, thanks for sharing this

I only came to see you

Useful

Can you please make a video on how to concatenate text for visible cells only in a column. I have a column in sheet A where I have applied filter and now I want to concatenate these values in sheet B. Text join take the filtered values as well.

Nice

Waaw… that’s the kind of content you wanna see as somebody working in finance.
Great content, as always 🙂

how lucky am i. familair with all mentioned. my favourite is alt+e+s = paste special.

Super

🎉🎉🎉excellent

I dont use excel a lot.. nice to know these tips 😊

I knew everyone

Amazing

Ctrl+Shft+3 for DD-MMM-YY

Wow that was wonderful

I am using 8

These are super helpful for navigating Excel. Thank you!

I use all of them.
Alt+e+a+a to clear all contents,
Alt+h+e+f to clear formats only

Last shortcut didn’t work out for me. When I used Alt + =, it enlarged the cell instead. Any advice? Thank you.

great

I know 8 out of 10

I know and use them all, am I a genius ?

The shortcut that I desperately want is to clear a filter. I don't want to remove the filter, I just want to go back to the full list. I've been using a macro to do this for over a decade. Sometimes I forget it's not a real Excel shortcut. But the problem is, because it is a macro, I lose the ability to use the undo function. Why doesn't this exist?

Leila, do you have a cheat sheet of all your shortcuts?

I really love learning with your videos. Thank you!

Alt+n+v : insert Pivot Table

Alt, a, c : Clear filters

Alt+down arrow, e : access Filter search box

Alt+down arrow, f, And then
e for Equals or
n for Not equals and so on

Very fast filtering navigation.

Ctrl+F3 Name Manager

Ctrl+Shift+u
I work with large nested functions in my formulas and regularly use Ctrl+Shift+u to toggle the formula bar into single row versus multirow view adjusting the latter with your mouse once or as needed but it's a quick way for me to jump between a single row and a four-row view.

9/10
Except ctrl+shift+1

I knew all, but ctrl+shift+L doesn't work in my AMD RYZEN Laptop, why so 😕

I just subscribed because of this vid, I was thought those differently so thank you.

Love your videos!!! Thanks so very much!!!

👍

Maam please make a video about advance aggregate functions

I appreciate it if someone tell me how to remove the US date format and make it regular.

Does this work on excel mobile?

Control + Shift + L is one of the most powerful shortcuts I use regularly. It saved a lot of time

I LOVE your channels.

Wow

F4

Very useful...

5 shortcuts I use almost daily 😊 !!

Is anyone can tell me the shortcut to format to yyyy-mm-dd, I'll be eternally grateful

ctrl shift and arrow key to select to the end of the range

When I typing a 16 digit account number in a cell the last digit is replacing with zero
How to overcome this

All of them

All

Mam
Ctrl +T se create ho jati h tabel
Agar hm create tabel ctrl +T ko remove krna ho to kya karege
Koi short key ya koi or option

Mam

Whoever created excel is a damn GEENUS!
















😜 misspelled on porpoise 😊