Alt+F8 :-Create, run, edit, or delete a macro.Ctrl+Tab:- Switch between open workbooks.Ctrl+F :- Search in a spreadsheet, or use Find and Replace.Alt+F1 :- Create an embedded bar chart based on select data (same sheet).F11 :- Create a bar chart based on selected date (on a separate sheet).Ctrl+F9 :- Minimize the workbook window.Ctrl+Shift+U :- Expand or collapse the formula bar.Shift+F9 :- Calculate active worksheets.F9 :- Calculate all work sheets in all open workbooks.
Alt+Q :- Go to the "Tell me what you want to do" box.F4 :- Repeat the last command or action.With the help of below keys you can manipulating workbooks, getting help, and a few other interface-related actions. Whatever version of Excel you are using this keys certainly useful and will work for it. You can also try it yourself in your data sheet to practice it. But all king of a complete list of every keyboard combo available in Excel. My following shortcuts list is also too long.
I have also tried to keep the list clean and simple, so you can do practice from it and take a print out also for further. And even if you pick up a few new trick's, it's worth it. Now, does anyone expect you to memorize all these keyboard combos? of course not! Everyone's needs are different, so some will be more useful to you than others. Following keys you should know to upscale yourself. Here I am going to explain and making you familiar with some important keys.
EXCEL MACRO SHORTCUT KEYS LIST WINDOWS
There are total 222 excel shortcuts for Windows and Mac.