The following keyboard shortcuts automate some of these tasks – some you probably already know, but take a look. We’re constantly entering something into a sheet. Ctrl + A Selects all contents of the worksheet. Below is the list of all the major shortcut keys in Microsoft Excel.
If you are familiar with windows operating system, you should be aware of most of them. CTRL + Select all cells whose formula the current cell referenced (directly) Ctrl + Page Down Move to the next sheet in the workbook. MS Excel offers many keyboard short-cuts. CTRL + A to select everything or after entry of a function name: Display the Formula Palette. Inserting content into an Excel sheet is a constant function for most of us. Control + 8 Excel 97: Hide column, Excel 2003: Hide Standard toolbar. These handy Microsoft excel shortcuts will help you enter data, create names, and complete functions easier and more efficiently once you start using them regularly. Please send us your comments on this article.A cheatsheet of Excel shortcuts that make inserting data faster General Excel shortcuts + F1: Show or hide the ribbon + F2: Switch to Print Preview + F9: Minimize the workbook window + Shift + U: Expand or collapse the. Select only the active cell when multiple cells are selected Microsoft Excel Shortcut Keys Ctrl+A Select All None Ctrl+B Bold Format, Cells, Font, Font Style, Bold Ctrl+C Copy Edit, Copy Ctrl+D Fill Down Edit, Fill, Down Ctrl+F Find Edit, Find Ctrl+G Goto Edit, Goto Ctrl+H Replace Edit, Replace Ctrl+I Italic Format, Cells, Font, Font Style, Italic Ctrl+K Insert Hyperlink. Select all cells from the current cell to A1 Select cells with formulas that directly reference the cell Here is the one-stop destination for all Keyboard Shortcuts, just take a look & memorize regularly for better performance in competitive exams & real-time situations. Select cells that are directly referenced in a formula Microsoft Excel is frequently used by finance and accounting professionals on a daily basis. Select cells that do not match the active cell Complete List of Excel Shortcuts 109 Shortcuts Without moving your fingers off the keyboard and without touching the mouse, you can quickly and effeciently accomplish the action and ultimately saving time. Shift + ↑ (up arrow key) Shift + ↓ (down arrow key)Ĭtrl + Shift + ↑ (up arrow) Ctrl + Shift + ↓ (down arrow) Shift + ← (left arrow) Shift + → (right arrow)
It is easy to go to the beginning or end of the workbook using the Command key, but I dont know how to produce the list of all the sheets. I have a particular workbook that has 75 sheets.
Shortcut keys for Excel for Mac are available on a separate page.Įxcel shortcuts for Mac Windows shortcut key list To do this I am trying to find the keyboard shortcut that produces a list of all the Excel sheets in a given workbook from which I can select any sheet. My Favourite Shortcut Keys Ctrl + W Close current workbook Ctrl + A, Select entire worksheet Ctrl + Z Undo. Ctrl + Insert the value of above cell into the current cell. Alt + Create the formula to sum all of the above cells. Ctrl + Tab Move between two or more open Excel files. Clicking on the To do this link will take you to a detailed page of the selected content. Ctrl + Page up & Page Down Move between Excel worksheets in the same document. Written in Excel for Microsoft 365 version 2202įor ease of viewing, shortcut keys for Excel for Windows are listed by usage.All shortcut keys for Excel - Excel Hack All shortcut keys for Excel