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 4. Total comments: 109
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
very useful thanks a lot...
short cut key on mail in and daily tip
This is nice shortkut key in excell thanks for add this
very useful very helpful
Thanks a lot
Good job
Your teachings are a value addition to me. May Allah blessed his mercy on you with rejoicings of this world and the heaven.
Regards
this is nice...all the information that i have been looking for are all in here... ♥♥♥
Thank's
very helpful, much better than watching the videos.
thankx much'
excel most important daily useful key send my email ID. please
i want excel shorcut