What are the shortcut keys of Microsoft Excel?

Microsoft Excel keyboard shortcuts

Ctrl + N: To create a new workbook.
Ctrl + O: To open a saved workbook.
Ctrl + S: To save a workbook.
Ctrl + A: To select all the contents in a workbook.
Ctrl + B: To turn highlighted cells bold.
Ctrl + C: To copy cells that are highlighted.
Ctrl + D:

What is the shortcut key for Save As in Excel 2010?

Use the shortcut F12 to display the Save As dialog box in Excel. Press CTRL + s to save an existing workbook.

Why do my shortcut keys not work in Excel?

Whichever problem you are having with your media keys, adding in the FN key to your shortcut will solve it. For example, if F12 for Save As is not working in Word, Excel or PowerPoint, that probably means that your media keys are dominant. You can just hit FN + F12 and your save as keyboard shortcut will work.

How do I find excel shortcuts?

Press the Alt key to display the ribbon shortcuts, called Key Tips, as letters in small images next to the tabs and options as shown in the image below. You can combine the Key Tips letters with the Alt key to make shortcuts called Access Keys for the ribbon options.

What is the shortcut key for select all?

Ctrl+A
Select all of the text in your document or on your screen by holding down the “Ctrl” key and pressing the letter “A”. 18 Tech Support Reps Are Online! Microsoft Answers Today: 65. Remember the “Select All” shortcut (“Ctrl+A”) by associating the letter “A” with the word “All”.

What is the shortcut for Undo?

To undo an action press Ctrl+Z. If you prefer your mouse, click Undo on the Quick Access Toolbar.

Are there any keyboard shortcuts for Excel 2010?

Microsoft Excel 2010 Keyboard Shortcuts. CTRL combination shortcut keys. CTRL+SHFT+ (. Unhides any hidden rows within the selection. CTRL+SHFT+&. Applies the outline border to the selected cells. CTRL+SHFT_. Removes the outline border from the selected cells. CTRL+SHFT+~.

Which is the keyboard shortcut for active worksheet in Excel?

Shift+F9: calculates the active worksheet. Ctrl+Alt+F9: calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. Ctrl+Alt+Shift+F9: rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

What are the keyboard shortcuts for Power Pivot in Excel?

Move to the first cell of selected column. Ctrl+Down arrow. Move to the last cell of selected column. Ctrl+Esc. Close a dialog or cancel a process, such as a paste operation. Alt+Down arrow. Open the AutoFilter Menu dialog. F5. Open the Go To dialog. F9. Recalculate all formulas in the Power Pivot window.

What are the shortcuts for the Alt key in Microsoft Office?

Press Alt again to see KeyTips for the options for the selected tab. In Office 2013 and Office 2010, most of the old Alt key menu shortcuts still work, too. However, you need to know the full shortcut. For example, press Alt, and then press one of the old menu keys E (Edit), V (View), I (Insert), and so on.