Excel Shortcut Keys, when starting with Microsoft Excel, knowing a few excel shortcut keys will reduce your work time and make it easier to work on Excel. Here are the most used excel shortcut keys to use when you just begin working with Microsoft Excel.

 These MS Excel Keyboard shortcuts for beginner works with all versions of MS Excel 2003, MS Excel 2007, MS Excel 2010, MS Excel 2013, MS Excel 2016, MS Excel 2019 & Office 365. 

Basic excel shortcuts for the Beginner.

1- CTRL O

        Open the Existing file.
2- CTRL S

        Save Active file.
3- CTRL C

        Copy Selection to clipboard
4- CTRL X

        Cut selection to the clipboard
5- CTRL A

        Select All
6- CTRL N

        Open New file
7- CTRL F

        Open Find Dialog box
8-CTRL P

        Open Printing Dialog Box
9-CTRL B

        Toggle Bold formatting 
10-CTRL I

        Toggle Italic formatting
11-CTRL U

        Toggle Underline formatting

Basic excel shortcuts for the Expert.

Formatting Shortcuts

CTRL + 1                                       Format Box

ALT + E + S + T                            Copy Format

ALT + H + 0                                  Increase Decimal

ALT + H + 9                                  Decrease Decimal

CTRL + SHIFT + 7                       Boxing

ALT + O + C + A                          Fit Column Width

ALT + H + O + R                         Change Tab Name

ALT + W + F                                (Un)Split Panes

ALT + W + S                                (Un)freeze windows

SHIFT + CTRL + #                      Date Format

SHIFT + CTRL + $ $                   Dollar Format

SHIFT + CTRL + % %                Percentage Format

ALT + “=”                                    Sum Function

Function Key Shortcuts

F1                                               Help

F2                                               Edit Cells

F3                                              Paste Name

F4                                              Repeat last action

F4                                              While typing a formula switch between absolute/relative refs

F5                                              Go to

F6                                              Next Pane

F7                                              Spell check

F8                                              Extend mode

F9                                              Recalculate all workbooks

F10                                            Activate Menu bar

F11                                            New Chart

F12                                            Save As

SHIFT + F2                               Insert a Comment

SHIFT + F8                               Add to Selection

SHIFT + F10                             Right Click

CTRL + F3                               Name a Cell

Windows Flag + D                  Minimize Programs

CTRL + A                                Select All

CTRL + B                                Bold

CTRL + C                               Copy

CTRL + D                               Fill Down

CTRL + F                                Find

CTRL + I                                 Italic

CTRL + N                               New Workbook

CTRL + O                               Open

CTRL + P                                Print

CTRL + R                               Fill Right

CTRL + S                               Save Workbook

CTRL + U                              Underline

CTRL + V                              Paste

CTRL + W                            Close Window

CTRL + X                            Cut

CTRL + Z                            Undo

Navigation Shortcuts

CTRL + Arrows                      Go to End of Continuous Range

SHIFT + Arrows                     Select A Cell Range

CTRL + SHIFT + Arrows       Highlight A Continuous Range

ALT + Tab                               Switch Programs

CTRL + Pg Up/Down             Switch Worksheets

 Columns & Rows Shortcuts

CTRL + 9                                       Hide Row

SHIFT + CTRL + 9                         Unhide Row

CTRL + 0                                        Hide Column

SHIFT + CTRL + 0                        Unhide Column

SHIFT + Spacebar                          Highlight Row

CTRL + Spacebar                            Highlight Column

SHIFT + CTRL + Plus sign             Insert Blank Cells

CTRL + Minus Sign                        Delete Selected Cells

SHIFT + ALT + Left Arrow            Group Rows/Columns

SHIFT + ALT + Right Arrow         Ungroup Rows/Columns

Some more Important Excel Shortcuts

Ctrl+1                                                               Changes the format of the selected cells.

Ctrl+2                                                                Bolds all cells in the highlighted section.

Ctrl+3                                                                Puts italics on all cells in the highlighted section.

Ctrl+4                                                                Underlines all cells in the highlighted section.

Ctrl+5                                                               Puts a strikethrough all cells in the highlighted section.

Ctrl+6                                                               Shows or hides objects.

Ctrl+7                                                               Shows or hides the toolbar.

Ctrl+8                                                              Toggles the outline symbols.

Ctrl+9                                                              Hides rows.

Ctrl+0                                                              Hides columns.

Ctrl+Shift+:                                                    Enters the current time.

Ctrl+;                                                               Enters the current date.

Ctrl+`                                                              Changes between displaying cell values or formulas in the worksheet.

Ctrl+’                                                               Copies a formula from the cell above.

Ctrl+Shift+”                                                    Copies value from the cell above.

Ctrl+-                                                              Deletes the selected column or row.

Ctrl+Shift+=                                                   Inserts a new column or row.

Ctrl+Shift+~                                                   Switches between showing Excel formulas or their values in cells.

Ctrl+Shift+@                                                  Applies time formatting.

Ctrl+Shift+!                                                    Applies comma formatting.

Ctrl+Shift+$                                                   Applies currency formatting.

Ctrl+Shift+#                                                   Applies date formatting.

Ctrl+Shift+%                                                  Applies percentage formatting.

Ctrl+Shift+^                                                   Applies exponential formatting.

Ctrl+Shift+*                                                   Selects the current region around the active cell.

Ctrl+Shift+&                                                  Places border around selected cells.

Ctrl+Shift+_                                                   Removes a border.

Ctrl++                                                             Insert.

Ctrl+-                                                              Delete.

Ctrl+Shift+(                                                    Unhide rows.

Ctrl+Shift+)                                                    Unhide columns.

Ctrl+/                                                               Selects the array containing the active cell.

Ctrl+\                                                               Selects the cells that have a static value or don’t match the formula in the active cell.

Ctrl+[                                                              Selects all cells referenced by formulas in the highlighted section.

Ctrl+]                                                              Select cells that contain formulas that reference the active cell.

Ctrl+Shift+{                                                   Selects all cells directly or indirectly referenced by formulas in the highlighted section.

Ctrl+Shift+}                                                   Select cells that contain formulas that directly or indirectly reference the active cell.

Ctrl+Shift+|                                                     Selects the cells within a column that don’t match the formula or static value in the active cell.

Ctrl+                                                                EnterFills the selected cells with the current entry.

Ctrl+                                                                SpacebarSelects the entire column.

Ctrl+Shift+                                                     SpacebarSelects the entire worksheet.

Ctrl+Home                                                      Move to cell A1.

Ctrl+End                                                         Move to the last cell on a worksheet.

Ctrl+Tab                                                          Move between Two or more open Excel files.

Ctrl+Shift+Tab                                               Activates the previous workbook.

By admin

One thought on “Awesome Fantastic Unique List Of Excel Shortcut Keys.”

Leave a Reply

Your email address will not be published.