Shortcut Keys | Action Functions |
---|---|
Alt+HFS | Increase Font Size |
Alt+HFF | Change Font Style |
Alt+HAT | Text to Top Align |
Alt+HAM | Text to Middle Align |
Alt+HAB | Text to Bottom Align |
Alt+HAL | Shift content to Left Align |
Alt+HAC | Shift content to Center Align |
Alt+HAR | Shift content to Right Align |
Alt+HM | Shift content to Merge & Center |
Alt+H5 | Content decrease Indent |
Alt+H6 | Content Increase Indent |
Alt+HFC | Change Text Color |
Alt+HH | Change Cell Color |
Alt+HB | Select and create a Border style around the Cells |
Alt+H1 | Text Bold |
Alt+H2 | Text Italic |
Alt+H3 | Text Underline |
Alt+HFP | Select Format Painter |
Alt+HVS | Paste Special |
Alt+HC | Copy Text |
Alt+HX | Cut Text |
Alt+HFQ | Rotating the Text Vertically or Diagonally |
Alt+HP | Numeric Percentage Style |
Alt+HK | Numeric Comma Style |
Alt+H0 | Numeric Increase Decimal |
Alt+H9 | Numeric Decrease Decimal |
Alt+HL | Select the Conditional Formatting Bar |
Alt+HLHD | Select and highlight the Duplicate vales in the desire range of cells |
Alt+HT | Table Format |
Alt+HII | Insert New Cell |
Alt+HIR | Insert New Row |
Alt+HIC | Insert New Column |
Alt+HIS | Insert New Sheet |
Alt+HDD | Delete cell |
Alt+HDR | Delete Row |
Alt+HDC | Delete Column |
Alt+HDS | Delete Sheet |
Alt+HOH | Change the Row Height |
Alt+HOA | AutoFit Row Height |
Alt+HOW | Change the Column Width |
Alt+HOI | AutoFit Column Width |
Alt+HOD | Default Width |
Alt+HOU | Hide and Unhide Row / Column / Sheet |
Alt+HOR | Rename Sheet |
Alt+HOM | Copy or Move Sheet |
Alt+HOT | Change the Tab Color |
Alt+HOP | Protect Sheet by using a Password option |
Alt+HOL | Lock Cell |
Alt+HOE | Format a Cell |
Alt+HSS | Auto Sum in a range of cells |
Alt+HAS | Auto Average in a range of cells |
Alt+HAC | Auto Count Numbers in a range of cells |
Alt+HAM | Auto count the maximum number in a range of cells |
Alt+HAI | Auto count the minimum number in a range of cells |
Alt+HFID | Fill Down or Use Ctrl+D |
Alt+HFIR | Fill Right or use Ctrl+R |
Alt+HFIU | Fill Up |
Alt+HFIL | Fill Left |
Alt+HFIJ | Justify the Text |
Ctrl+Shift+L | Create a Filter of a selected Cells |
Ctrl+F | Find the specific Value |
Ctrl+H | Find and Replace the specific Value, Number or Text |
Ctrl+S | Data saving in the active workbook |
Ctrl+C | Copy Text, Number, Image or anything in the desire range of cells, array or range |
Ctrl+X | Cut Text, Number, Image or anything in the desire range of cells, array or range |
Ctrl+V | Paste Text, Number, Image or etc. |
Ctrl+Z | Undo: Quickly to rescind a previous action |
Ctrl+Y | Redo: the previous action |
Alt+HVSE | Paste Special → Transpose: Convert data into rows/columns |
Ctrl+Shift+↑ | Selection of Cells and Move Up |
Ctrl+Shift+↓ | Selection of Cells and Move Down |
Ctrl+Shift+→ | Selection of Cells and Move Right |
Ctrl+Shift+← | Selection of Cells and Move Left |
Ctrl - L | Delete (Shift Cells Left) |
Ctrl - U | Delete (Shift Cells Up) |
Ctrl - R | Delete (Entire Row) |
Ctrl - C | Delete (Entire Column) |
Ctrl+) | Hide Column |
Ctrl+( | Hide Row |
Alt+HAN | Key for select or change currency sign (dollar, Pound, EU, PRC, etc) |
Free Excel Calculators
Get your work done easily by Excel based Calculators.