Menu
Excel shortcut keys But often, it can be hard to remember these hotkeys — especially if you regularly switch between the Mac and PC versions of Excel. To that end, we've compiled this handy list of all the Excel shortcuts you should know, for both Mac and PC.
250 Excel Keyboard Shortcuts M icrosoft Excel having so many unbelievable capabilities that are not instantly perceived. Excel Shortcut keys are most useful and usable to save the time. Shortcut keys help to provide an easier and usually quicker method of directing and finishing commands in Microsoft Excel. Mostly we prefer to use the shortcuts as it’s kind of amazing how much time we can save by not using the mouse clicks. Keyboard shortcuts in Excel are commonly accessed by using the ALT, Ctrl, Shift, Function key and Window key.
We really liked that windows gives us multiple ways to perform the task in Excel, let’s say we want to save a file, either we can press the key “Ctrl+S” or “Shift+F11”. Below are the amazing Shortcuts for Excel category wise, in which you will find the Excel formula shortcuts, Excel copy paste shortcuts, Excel keyboard shortcuts to insert row, Excel keyboard shortcuts to select row, Keyboard shortcuts for VBA and Excel hot keys (add more alt shortcuts to Excel). Keyboard shortcuts for Dialog Box:- Entering Data shortcuts:- File Commands:- Keyboard shortcuts for Format:- Formulas shortcuts:- General keyboard shortcuts:- Important Hot Keys:- Shortcuts for Navigating:- Keyboard shortcuts for selecting rows/column/cell:- Window shortcut keys:- Workbook shortcut keys. Your site has been a true gem. I am working in an office and have taken on most of the duties of Accounting, Client management, Front office, what ever else the boss wants.
I never would have been able to make the spreadsheets I have without your help and the info I have received in the forums. With your help I went from part time to a very needed piece of the office puzzle.
Could you email me the excel and pdf version of your shortcut list. Also know that I am truly, truly thankful of all the work you have dedicated to this site. Regarding navigating, keep in mind that several of the tips shown are for edit mode, including but not limited to CTRL+RIGHT, CTRL+LEFT, HOME & END.
Here are a few that I failed to notice in the list: To jump to the cell before the 1st blank cell to the right: END followed by RIGHT To jump to the cell before the 1st blank cell down: END followed by DOWN To jump to the next sheet: CTRL+PGDN To jump to the previous sheet: CTRL+PGUP To jump one screen to the right: ALT+PGDN To jump one screen to the left: ALT+PGUP Regarding using ALT+TAB to go to a different application, hold down the ALT key while repeatedly pressing the TAB key until the application you want is highlighted, then let go of the ALT key. If you press TAB too many times and pass the application you want, without letting go of the ALT key press SHIFT+TAB to back up. This is not Excel-specific but a function of Windows.
![A List Of Excel Shortcuts A List Of Excel Shortcuts](/uploads/1/2/5/6/125633678/866316480.jpg)
Regarding the shortcuts for unhiding rows & columns, CTRL+SHIFT+( works for unhiding rows, but CTRL+SHIFT+) has never worked for unhiding columns (I have 2007). To unhide columns I need to type ALT H O U L instead.
Remember 1st to select a range that includes the row(s) or column(s) you want to unhide.