Thursday, 18 February 2016

MS Excel All Important Keyboard Shortcut Keys for Excel 2003 to 2016

MS Word shortcut key,excel 2016 shortcut key, excel 2010 shortcut key,table shortcut key,how to create shortcut key,ms excel important shortcut key,MS excel All Important Keyboard Shortcut Keys for excel 2003 to 2016, excel 2007 shortcut key,keyboard shortcut key,all ms excel shortcut key,tablet,paragraph,line,how to use,ms office shortcut key,ms office tips & tricks,new shortcut key of excel,best,all shortcut keys,how to use shortcut key,excel, insert column, insert row, new excel shortcut key, all excel shortcut key,  Sum all of the above cells, Left Alignment, Right Alignment, Center Alignment, Insert Column & Row, Delete Column & Row, Insert new worksheet, Delete worksheet, Insert symbol, Spell Check, Select Entire Column, Select Entire Row, Font size, Font style, Link formula, Move to next worksheet, Move to previous worksheet, Hide Row, Unhide row, Hide column, Unhide column, apply same formula, Find and Replace, Edit cell, Go to a specific cell no, Next line, Open the Format Cells window, Insert number format, Insert Currency, Show/Hide Menu/Ribbon, Find & Replace, Move to Edge of data region, Open Insert Function Box, Move to Previous cell, insert Date, Insert TimeIf you don’t know basic keyboard shortcut key in Excel? than you must be learn, because shortcut keys help to work fast, in this post I have tried to mention some very useful and important shortcut key of Microsoft Excel, these key will work all the version of Excel like, 2003, 2007, 2010, 2013 and 2016.  (Watch below video to know how to use)

Alt + =                           Sum all of the above cells.
Alt+HAL                          Left Alignment
Alt+HAR                         Right Alignment
Alt+HAC                         Center Alignment
Ctrl+Shift, +                    Insert Column & Row
Ctrl -                               Delete Column & Row
Alt+Shift+F1                   Insert new worksheet
Alt+EL                            Delete worksheet
Alt+I,S                            Insert symbol
F7                                   Spell Check
Product                          = move cursor on cell * press enter
Sum                                = move cursor on cell + press enter
Ctrl+Shift+Down arrow   Select Entire Column
Ctrl+Shift+left arrow”      Select Entire Row
Ctrl+shift+P                    Font size
Ctrl+Shift+F                    Font style
= Page up                      Link formula
Ctrl+Page Down             Move to next sheet
Ctrl+Page Up                  Move to previous sheet
Ctrl+9                             Hide Row
Ctrl+Shift+9                    Unhide row
Ctrl+0                             Hide column
Ctrl+Shfit+0                    Unhide column (If not work use mouse)
CTRL+B                          Bold formatting.
CTRL+D                          Fill Down command to copy the content
CTRL+F                           Find and Replace
CTRL+I                           Italic formatting.
CTRL+N                          Creates a new
CTRL+O                          Open
CTRL+S                           Save file
CTRL+U                          Underline
F2                                   Edit cell
F5                                   Go to a specific cell
Alt + Enter                      Next line
Ctrl + 1                           Open the Format Cells window.
Ctrl + Shift + 1                Insert 00
Ctrl + Shift + 4                Insert Currency
Ctrl+F2                           Print preview
Ctrl+F1                           Show/Hide Menu/Ribbon
Ctrl+H                            Find & Replace
Ctrl arrow keys                Move to Edge of data region
Shift+F3                          Open Insert Function Box
Tab                                 Move to Cell
Shift+Tab                        Move to Previous cell
Ctrl+;                               Insert Date
Ctrl+Shift+;                     Insert Time

Watch video tutorial… Please like, share & subscribe 

No comments:

Popular Posts