#Microsoft Excel Short Keys

 

Microsoft Excel Short keys

Ctrl+A--- Select All               

 Ctrl+B--- Bold          

Ctrl+C--- Copy   

Ctrl+D---Fill Down                

Ctrl+E--- Center Align            

Ctrl+F--- Find

Ctrl+G--- Goto                

Ctrl+H---Replace          

Ctrl+I--- Italic 

 Ctrl+K--- Hyperlink   

          

Ctrl+N---New        

Ctrl+O---Open

Ctrl+P--- Print                 

Ctrl+U---Underline            

Ctrl+V---Paste

Ctrl+W---Document Close                  

Ctrl+X--- Cut            

Ctrl+Y--- Repeat   

Ctrl+Z--- Undo                

Alt+F8---Open the Macro

Alt+Shift+F2---Save the current Worksheet    

Alt+F11---Open Visual Basic Editor

Alt+Shift+F1----Create New Worksheet    

Alt+’---Allow Formatting on  dialogue Box

Alt+Space bar---Open the System Menu   

Alt+Tab---Cycle Through Applications

F1---Help          F2---Edit the Cell       

F3---After a name has been created it will paste

F5---Goes to specific cell            F6---Move the next pane

F7---Spelling checker                  F8---Enter Extends Mode

F9---Recalculate every book        F10---Activates the Menu bar

F11---Create a chart from selected data   F12---Save As

Ctrl+1---Change the format of selected cell

Ctrl+2---Bold all cells in highlight selection

Ctlr+3---Italic all cells in highlight Area

Ctrl+4---Underline cells in Selected Area

Ctrl+5---Put Strikethrough on Selected Area

Ctrl+6---Show the hide objects

Ctrl+7---Show or hide toolbars

Ctrl+8----Toggle the Outline Symbols

Ctlr+0---Hide Columns

Ctrl+Shift+;---Enters the Current time

Ctrl+;---Enters the Current date

Ctrl+- ---Delete the selected rows or columns’

Ctrl+shift+F12---Print the Current Worksheet

Ctrl+Shift+F6---Moves to the previous Worksheet Window

Ctrl+F12---Opens a File

Ctrl+F10---Maximize the Currently selected window

Ctrl+F9---Minimize the current Window

Ctrl+F5---Restore Window Size

Ctrl+F4---Close Current Windows

Ctrl+Shift+@---Apply time formatting

Ctrl+Shift+!---Apply Comma Formatting

Ctrl+Shift+$---Apply currency Formatting

Ctrl+Shift+#---Applies date Formatting

Ctrl+Shift+%---Applies formatting Percentage

Ctrl+Shift+^---Applies Exponential Formatting

Ctrl+Shift+(---Unhide Rows

Ctrl+Shift+)---Unhide Columns

Ctrl+Enter--- Fill the Selected Cell in current entry

Ctrl+Space Bar---Select the Entire Column

Ctrl+Tab---Move between two open Excel files

Ctrl+Shift+A---Insert Arguments name in to formula

Ctrl+Shift+F---Opens the drop down Menus of fonts

Ctrl+Shift+O---Select All of the cells that contains comments

Shift+Insert---Paste the clipboard data

Shift+Home ---Highlight all text to left of the cursor

Shift+End---Highlight all text to right to the cursor

Shift+Up Arrow---Extend the highlighted Area Up to one cell

Shift+Down Arrow---Extend the highlighted area down to one cell

Shift+Left Arrow---Extend the highlighted Area Left one to character

Shift+Right Arrow---Extend the highlighted Area Right one to character