Good one 👍 I had a small doubt Assuming I work at an office where I'm asked to only use my keyboard. I have opened the Function Argument Dialog Box for Vlookup Function and want to select the cells (no mouse with me), what shortcut should I use to select the cells?
Which Excel version you are using? If you are using Excel 2013 (or previous) make sure to activate it from Tools > Options > Advanced > Editing Options > Automatically Flash Fill.
👉 FREE EXCEL COURSES + E-BOOKS: excelchamps.com/p/bundle
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
JP Morgan linked your channel to there course. Congrats.
Came here from them too 😊
Same
very useful shortcuts.👌👌
glad to hear that
Oh my goodness! THANK YOU! These were amazing! Now I have to watch every single video you have! WOW!
glad it helps
Shift+F8, F7, Alt+O+a, Alt+v+u was new for me!
Really these shortcut keys very helpful,thank you team
Welcome
Fav. Short cut key is multiple Total.
mine too.
Thank you Puneet for these really useful keyboard shortcuts. I didn't knew many...
glad to hear this, Vijay.
Best shortcuts dear puneet Thanks a lot
I'm happy you found it useful, Rajesh.
impressive now I'm subscribing your channel bro
Thank you. I didn't know about Alt O A for auto format.
Welcome.
Hi Puneet, thank you. Quite handy.
I'm glad you liked it, Jayesh.
Very informative and time saving , Sir.
Glad you liked it, Ranjan Ji
thanks !
these keys are great help
welcome.
great content, thanks !
Glad you liked it!
CTRL+E MY FAV
u knw JPM linked me here. WOW. ...
forage?
@AniketSable-h7z yes😮
Alt O A for auto format is not working on Mac for me.
there is option availabe where we can change the chart type after allowing alt +f1
In my system, Alt+D+O is not working but Alt+D+O+O is working to open in-built user form.
Thanks,
You're welcome!
Good, thanks.
You're welcome,
Alt-D-O is not working
why don't these work on my Mac ?\
PENEET YOU ARE GREAT
thanks for your words, Reuben.
Good one 👍
I had a small doubt
Assuming I work at an office where I'm asked to only use my keyboard. I have opened the Function Argument Dialog Box for Vlookup Function and want to select the cells (no mouse with me), what shortcut should I use to select the cells?
navigation keys.
ctr e
FLASH FIILL I CAN NOT DO THAT. Control E DOES NOT WORK, WHY;I DO EXACTLY THE STEPS!
Which Excel version you are using? If you are using Excel 2013 (or previous) make sure to activate it from Tools > Options > Advanced > Editing Options > Automatically Flash Fill.
@@excelchamps thank you very match , i will see that!
i have office 2007 and in Editing Options i see
@@dtsioustas Got it. They didn't add this option in 2007 and 2010.
Alt H O I Alt H O A
Best shortcuts dear puneet Thanks a lot
Most welcome