Friday, 17 February 2017

Excel Some Useful Keyboard Shortcuts

Excel Some Useful Keyboard Shortcuts

Excel Some Useful Keyboard Shortcuts
Shortcut key Action Menu equivalent comments
Alt or F10 Menu Go to Menu bar
Alt+’ Format Style dialog box Format the Style
Alt+= AutoSum Sum Formaula Showing in Cell
Alt+Down arrow Display AutoComplete list Displaying Auto Complete Data List
Alt+F1 Insert Chart Insert the Chart
Alt+F11 Visual Basic Editor Tools, Macro, Visual Basic Editor
Alt+F2 Save As Save File to Save As
Alt+F4 Exit File Exit
Alt+F8 Macro dialog box Macro dialog box Tools
Alt+Shift+F1 New worksheet Insert New Worksheet
Alt+Shift+F2 Save Save the File
Ctrl + Shift + L Filter Filter the Row
Ctrl W Close Close the Open File
Ctrl+- Delete Delete the Rows, Columns and Cells Right or Down Depends on selection
Ctrl+! Format cells dialog box Font Tab Open in Format Cell Tool
Ctrl+# Italic Cell Font Style Change to Italic toggle
Ctrl+$ Underline Cell Font Style Change to Underline toggle
Ctrl+% Strikethrough Cell Font Style Change to Strikethough
Ctrl+( Hide rows Hide the Row
Ctrl+) Hide columns Hide the Coloumns
Ctrl+; Insert Current Date Add the Current Date
Ctrl+@ Bold Cell Font Style Change to Blod toggle
CTRL+[ Select all cells directly referenced by formulas in the selection. Referene Contains Cell Easily Find
CTRL+] Select cells that contain formulas that directly reference the active cell. Referene Formula Cell Easily Find
Ctrl+` Column Widht Coloumn Width Increase Double Size
Ctrl++ Insert Insert the Rows, Columns and Cells Right or Down Depends on selection
Ctrl+A Select All Selecting Entire Sheet
Ctrl+Alt+V Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. Purpose Paste and Paste Special
Ctrl+Alt+V, Press A Displays the Paste Special dialog box, Selecting All Purpose Paste and Paste Special
Ctrl+Alt+V, Press V Displays the Paste Special dialog box, Selecting Values Purpose Paste and Paste Special
Ctrl+B Bold Cell Font Style Change to Bold toggle
Ctrl+C Copy As Your Wish to Copy Selected Cells
Ctrl+D Fill Down Copy to Down Cell
Ctrl+F Find Find What you Find
Ctrl+F1 Hide the Menubar Hiding the Menubar
Ctrl+F10 Maximize or restore Down window Maximize and restore Down the window
Ctrl+F11 Macro sheet Inster the Macro Worksheet
Ctrl+F12 File Open Open the File
Ctrl+F2 Format Shape & Print 1st Side to Open Format Shape Tool, Next Immediately Open Print Option
Ctrl+F3 Name Manager New Name add to Refer Cell (Any Cell You Want add New Name)
Ctrl+F4 Close Close the Open File
Ctrl+F5 Restore Down Window Size Change
Ctrl+F6 Next workbook Next Workbook Window Change
Ctrl+F7 Move window 1st Change the Window Size Pressing Ctrl+F5, After Window Move to Any Area
Ctrl+F8 Add to selection Multiple Different Cell Add to Selection
Ctrl+F9 Minimize workbook Minimize the Worksheet
Ctrl+G Go to Type the Reference Cell Numver Want to Go
Ctrl+H Replace Find What you Find to Replace With Another Word
Ctrl+I Italic Cell Font Style Change to Italic toggle
Ctrl+K Insert Hyperlink Hyperlink Insret
Ctrl+N New Workbook New File
Ctrl+O Open Open File
Ctrl+P Print Print File
Ctrl+R Fill Right Copy to Right Cell
Ctrl+S Save Save the Workbook File
Ctrl+Shift+& outline border around selected cells Place outline border around selected cells
Ctrl+Shift+( Unhide rows Unhide the Hided Rows
Ctrl+Shift+) Unhide columns Unhide the Hided Coloumns
Ctrl+Shift+: Insert Current Time Add the Current Time
Ctrl+Shift+_ Remove outline border Remove outline border around selected cells
Ctrl+Shift+A Insert argument names into formula 1 st Type the Formula Name in Cell Next Press the Shortcut
Ctrl+Shift+F1 Full Mode Hide the QuickAccess, Menu and Status bar
Ctrl+Shift+F12 Print Print File
Ctrl+Shift+F3 Create name by using names of row and column labels Insert, Name, Create
Ctrl+Shift+F6 Workbook Switch Last Workbook Switch Between Multiple Sheets
CTRL+SHIFT+SPACEBAR Selects the entire worksheet.  Selecting he entire worksheet. 
Ctrl+Spacebar Select the entire column Selecting the entire column
Ctrl+Tab In the toolbar next toolbar Go to Next Option in Toolbar
Ctrl+Tab In a workbook: next workbook Switch Next Workbook
Ctrl+U Underline Cell Font Style Change to Underline toggle
Ctrl+V Paste 1st Copy the Selected Area, And Next Paste to Anywhere in Workbook
Ctrl+X Cut As Your Wish to Cut Selected Cells
Ctrl+Y Repeat 1st Using Undo After You can use the Repeat
Ctrl+Z Undo Sack to Steps Previous
Enter Move to Down Cell Move to Down Cell
F1 Help Excel Help
F10 Menu Go to Menu bar
F11 New Chart Insert Chart
F12 Save As File Save to Save As
F2 Edit You Can Edit the Word
F4 While typing a formula, switch between absolute/relative refs Change the Formula While you Formula Adding (For Example =Vlookup(a2 Now Press F4)
F5 Go to Type the Reference Cell Numver Want to Go
F6 Menu & Status Bar 1 time Press Go to Status Bar, 2 times Press to Menu Bar
F7 Spell check Spelling Modified
F8 Extend mode Extend Selection
SHIFT+BACKSPACE Cells Selected select only the active cell, With multiple cells selected With Hold Shift+Down Arrow
Shift+Ctrl+F Font Tab Format Cell Font Tab Open in Format Cell Tool
Shift+Ctrl+F6 Previous workbook window Previous Workbook Window Change
Shift+Ctrl+P Font Tab Format Cell Font Tab Open in Format Cell Tool
Shift+Ctrl+Tab In the toolbar: previous toolbar Go to Previous Option in Toolbar
Shift+Ctrl+Tab In a workbook: previous workbook Switch Previous Workbook
Shift+F10 Display Options If you Don't Want Use the Mouse Right, Then Use the Shortcut (And Also Shortcut Available Keyboad)
Shift+F11 New worksheet Insert the New Worksheet
Shift+F12 Save File Save
Shift+F2 Edit cell comment Insert and Edit Comments
Shift+F3 Select a Formula Function Insert a Furmula Function
Shift+F4 Repeat last action Repeat the Last Actions Works while not in Edit mode. (1st Using Find What : What You Find, After You Can Use Previuosly What You Find)
Shift+F5 Find Find What you Find
Shift+F6 Menu & Status Bar 1 time Press Go to Status Bar, 2 times Press to Menu Bar
Shift+F7 Thesaurus Type the words in groups of synonyms and related concepts
Shift+F8 Add to selection Multiple Different Cell Add to Selection, How to Use Press 2 Times, After Add to Selection
Shift+Spacebar Select the entire row Selecting the entire row
Shift+Spacebar and Ctrl+ - Delete Delete the Selected Area Row
Shift+Spacebar and Ctrl+ + Insert Insert the Selected Area Row
Shift+Tab Move to Previous Left Cell Move to Previous Left Cell
Tab Move to Right Cell Move to Right Cell
Esc Escape Stop the Selected Cells Copy
PgUp Page Up Go to Next WorkSheet
PgDn Page Down Go to Previous WorkSheet

No comments:

Post a Comment