Hello there.
I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to tell you about:
Excel shortcut keys begin with "Ctrl" for 89 Keys.
If you are seeking for Excel shortcut key to complying with any of your particular sake. Here is the place for you to take a glance and pick the one you like. In addition, you can save our site as your remark about the future visit.
This is the list of Excel version 2010 shortcut way by using keyboard key beginning with "ALT" key button for the main key and plus together with another key(s) like letters, numbers, comma, period, semicolon, arrow keys, Caps Lock key, control keys, function keys, page up, page down, command key button and more.
Tip Quiz
What is the shortcut to open the visual basic editor?
Benefits:
• The mouse will be never used for this shortcut key. Therefore, you can say goodbye to your mouse from now on. Why we bring thing unless we can leave it at its home?
• It is a very simple way to get the outcome instantly.
• It is a great deal for Excel users having an alternative to handling worksheets.
• Spend less of your time. Nevertheless, vice versa save your energy.
Table Excel shortcut key starting with [Alt] and plus other keys:
Excel Shortcuts
|
Result
|
---|---|
ALT+' (APOSTROPHE / SINGLE QUOTE) | To display the style dialog box. |
ALT+= | To insert the autosum formula. Then input array of cells in it. |
ALT+A ... ALT+Z | In dialog box, to select an option, or select or clear a check box. |
ALT+ARROW DOWN | In the Excel dialog box, to display the autocomplete list such as in cell with dropdowns or Auto Filter. |
ALT+ARROW DOWN | Display in the Auto Filter list for the current column on the field with column head. |
ALT+ARROW DOWN | To open the selected drop-down list in the dialog box. |
ALT+ARROW UP | Closing the Auto Filter list for the current column. |
ALT+B | To set bottom border. (Cell Format in 'Border' dialog window). |
ALT+C | To move the selected field into the "column area" (In Pivot Table). |
ALT+D | To move the selected field into the "data area" (In Pivot Table). |
ALT+D | To set diagonal and down border. (Cell Format in 'Border' dialog window). |
ALT+E THEN L | To delete current worksheet (Permanent delete). |
ALT+E THEN M | To move or copy current worksheet (Display menu box). |
ALT+ENTER | Start a new line in the same current activated cell. |
ALT+F1 | To create and insert chart with data in range of current cells selected. |
ALT+F10 | Selecting the active tab of the 'Excel Ribbon Tap' and activate the access keys. Just key Alt+F10 gain to cancel. |
ALT+F11 | Opening the visual basic editor to create macros. |
ALT+F4 | To close excel workbook. (Don't forget to save your latest updated file before use this tip). |
ALT+F8 | To display the macro dialog box that prompt to input macro name. |
ALT+H THEN AC | To align data center. |
ALT+H THEN AL | To align data in cell left. |
ALT+H THEN AR | Align data right. |
ALT+L | Display the Pivot Table field dialog box. |
ALT+L | To set left border. (Cell Format in 'Border' Dialog window). |
ALT+O(LETTER) THEN HR | Rename current worksheet. |
ALT+P | To move the selected field into the page area in Pivot Table. |
ALT+PAGE DOWN | To move one screen to the right in a current worksheet. |
ALT+PAGE UP | To move one screen to the left in a current worksheet. |
ALT+R | Move the selected field into the row area in Pivot Table. |
ALT+R | To set right border. (Cell Format in 'Border' Dialog window). |
ALT+SHIFT+ARROW LEFT | To ungroup rows or columns. |
ALT+SHIFT+ARROW LEFT | To ungroup selected Pivot Table items. |
ALT+SHIFT+ARROW RIGHT | To group rows or columns. |
ALT+SHIFT+ARROW RIGHT | To group selected Pivot Table items. |
ALT+SPACE | To display the control menu for main excel window e.g. restore, move, size,.. |
ALT+T | To set top border. (Cell Format in 'Border' Dialog window). |
ALT+U | To set diagonal and up border. (Cell Format in 'Border' Dialog window). |
Tip Answer
Link recommendedπ : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'
Link recommendedπ : English Numbers In Words 1 to 1000000
That brings me to the end of my posting. I'm gotta say goodbye for now.
Thanks for reading.
Posted by: Michael Leng
I've known, then I've grown.
See more another tips:
- Excel Shortcut Key Begin With [Ctrl] And Follow With Another Keys List
- My Excel File Is Too Big | How To ‘Reduce Excel Size’ To Become Smaller
- Excel Solving "This Workbook Contains Links To Other Data Sources"
Comments
Post a Comment