Learn the most useful Excel keyboard shortcuts to manage workbooks, format data, work with formulas, navigate between worksheets and more. Continue reading
by Alexander Frolov, updated on
Learn the most useful Excel keyboard shortcuts to manage workbooks, format data, work with formulas, navigate between worksheets and more. Continue reading
Comments page 3. Total comments: 109
Plz mail me this shortcuts keys data
Very useful this excel keys detail
Plzzz sent most useful formulas of excel for company job into my mail I'd,shortcut keys also
Very useful daily use shortcuts.
This is a good for every one if any person has interest in Excel program ......
thanks for sharing this.it is very helpful
VERY USEFULL
Thanks alot for your help
Thanks my man. You made me look good at work.
Thank You
You were very helpful
Hmm good
Dear Team,
These Shortcut keys of excel is a basic keys that every excel Worker knows very well.
Note:- You need to improve and you have to provide us best excel shortcut keys which is useful for us.
Thank You!!
these are shortcut key of excel very useful. Thanx a lottttt
Want very usefull shortcut keys use in exel plz send me ok
Send on my whatsapp no.
8090636724
Plz bro in 2-6 days ok
please i need shortcut to change from lower case to upper case in excel
usefull
very usefull
thanks for a wonderful help.
Thanks for give sort keys
ctrl home,
ctrl shift end
will change my life!!!
Hi ctrl + o
You open my heart.
Tnx alot
Nice information
Great list!! Helpful quick tips. The select data ones were new to me. Thanks!
Could u like to teach me how to insert phone number which starts with Zero in excel cells .
How can I insert long name or information in a cell but it will show same size cell ? .....waiting for ur reply ...........
Thanks
1.Put apostrophe before inserting number.
2.Home - Format - Autofit Column Width.(You can use the shortcut - Alt+HOI)
‘Excel shortcuts and tricks’ is my favourite topic and I love them. Apart from keyboard shortcuts I also love using something called ‘ribbon shortcuts’ – press F10 or Alt to start with, then select the letter displayed accordingly to get the command you want. After a little practise, the steps should be able to memorised and performed quickly from head – this is much faster than clicking using the mouse.
For example:
F10, W, F, F – to freeze/ unfreeze panes
F10, A, C – to clear all filters
Very nice.It's very helpful to everybody.
Some shortcuts that I use everyday but not listed in the first post:
Ctrl + Shift + L (to apply/ remove filter)
Ctrl + B / I / U (don’t need to explain do I?)
F7 (spell check)
Ctrl + roll the mouse wheel (zoom in and out)
Hold down Ctrl, click hold a worksheet tab, drag across to the right hand side, release the mouse then release the Ctrl key (this duplicates the current worksheet instantly on a new tab, surprisingly useful in some situations)
Also, customized the quick access toolbar to my exact requirement, place it below the ribbon, and hide the ribbon (Ctrl + F1) – this is my Excel layout
very useful
thnxs to help us
Thank u so much
excel shortcut key
How Can One Insert Numbers Automatically
Write 1 and 2, then select both the Cells and drag the selection downward.
Dear Respected Sir,
Please get me work easy way to do the excel sheet with all functions with total solution to do my daily reports and invoices multi national company on going jobs.
RAMNATH DIGHULE
I HOPE
I TO I
MY LARNING I HOPE YOU.....
THAKU FOR TOU
I AM MY BEST KNOWLDGE OF EXELE
It's very helpful.I can use the excel more faster.Thank you very much.
Great to know.
As'Salam-o-Alaikum
Very Instructive and must for every Excel user
Highly Recommended
I wanted to include an Important one for VBA Programming
Alt+F11 to open VBA(Visual Basic for Applications)IDE
my 20 to exsl untfortun due volume fo commetsrccived
good,
thanks so much,very helpful
i need vlookup formula in shortcut to complete the work fast....
what is the shortcut key to Vlookup
yes it is very beautyfull shartcut evaryone persons you's fully then better
Very helpful,easy to understand & remember shortcuts.
Hope for more shortcuts soon.
thanks its very useful formulas
It was really helpful. Thanks a ton for this awesome content made available.
Its very nice though an good job
Explained is good but Pls put some example images of particular shortcut keys.Thanks
Thanks a lot :) very helpful, KUDOS!
very useful
Dafur you are wasting your time
I love this app thank u its nice and helpful