Ms Excel Short Keys

MICROSOFT EXCEL

SHORTCUT KEYS:

  ·     CTRL + N = Create A New Workbook
·     CTRL + O = Open
·     CTRL + S = Save
·     CTRL + A = Select All
·     CTRL + X = Cut
·     CTRL + C = Copy
·     CTRL + V = Paste
·     CTRL + Z = Undo
·     CTRL + Y = Redo
·     CTRL + G = Go To
·     CTRL + F = Find And Replace (Find)
·     CTRL + H = Find And Replace (Replace)
·     CTRL + B = Bold
·     CTRL + I = Italic
·     CTRL + U = Underline
·     CTRL + L/T = Create Table
·     CTRL + P/F2 = Print Preview
·     CTRL + K = Insert Hyperlink
·     CTRL + W = Close Workbook
·     CTRL + R = Copy Cell Rightwards
·     CTRL + D = Copy Cell Downwards
·     CTRL + 1 = Display ‘Format Cells’
·     CTRL + 2 = Apply/Remove Bold Formatting
·     CTRL + 3 = Apply/Remove Italic Formatting
·     CTRL + 4 = Apply/Remove Underlining
·     CTRL + 5 = Apply/Remove Strikethrough
·     CTRL + 6 = Hide/Display Objects
·     CTRL + 8 = Hide/Display Outline Symbols
·     CTRL + 9 = Hide The Selected Rows
·     CTRL + 0 = Hide The Selected Columns
·     CTRL + PageUp = Switch Between Worksheet Tabs (Left to Right)
·     CTRL + PageDown = Switch Between Worksheet Tabs (Right to Left)
·     CTRL + SHIFT + ( = Unhide Rows
·     CTRL + SHIFT + & = Apply Outline Border
·     CTRL + SHIFT + _ = Remove Outline Border
·     CTRL + SHIFT + ~ = Apply General No. Format
·     CTRL + SHIFT + $ = Apply Currency Format
·     CTRL + SHIFT + % = Apply Percentage Format
·     CTRL + SHIFT + ^ = Apply Scientific No. Format
·     CTRL + SHIFT + # = Apply Date Format
·     CTRL + SHIFT + @ = Apply Time Format
·     CTRL + SHIFT + ! = Apply Number Format
·     CTRL + SHIFT + : = Enter Current Time
·     CTRL + SHIFT + PLUS(+) = Display Insert
·     CTRL + SHIFT + - = Display Delete