Download M.s excel shortcuts and more Exercises Computer science in PDF only on Docsity!
CTRL Shortcuts
CTRL + A Select All CTRL + B Bold CTRL + C Copy CTRL + ALT + V Paste Special CTRL + D Fill Down CTRL + G Go to CTRL + H Replace CTRL + I Italic CTRL + K Insert Hyperlink CTRL + N New Workbook CTRL + O Open File CTRL + P Print CTRL + R Fill Right CTRL + S Save Workbook CTRL + T Create Table CTRL + U Underline CTRL + V Paste CTRL + W Close Window CTRL + X Cut CTRL + Y Repeat CTRL + Z Undo
CTRL + 0 Hide Column Shift + CTRL + 0 Unhide Column CTRL + 1 Format Box CTRL + 5 Strike Through CTRL + 9 Hide Row Shift + CTRL + 9 Unhide Row
CTRL + SPACE Select Column
CTRL + ~ Show Formulaes / Values CTRL + ' Copy Above Formula CTRL + [ Precedents CTRL + ] Dependents CTRL + ; Display Date SHIFT + CTRL + : Display Time
ALT Shortcuts Formulas & A
= ( Equal Sign ) ALT + Tab Switch Program Shoft + F ALT + ' Display Style Alt + ''='' Ctrl + ' (apostrophe) ALT + W + S (Un) Split Panes ALT + W + F (Un) Freeze Windows ALT + H + O + M Move / Copy a Sheet ALT + H + D + S Delete a Worksheet
ALT + W + Q Change View Signing ALT + H + O + I Fit Column Width ALT + H + O + R Change Tab Name Alt +H + E + A Clear Cell Alt + H + H + L Conditional Format Alt + H + A Align ALT + H + F + P Format Painter ALT + H + F Formatting ALT + W + F + V Print Preview Alt + F4 Close Program ALT + F8 Macro Box ALT + F11 Visual Basic Editor
Column & Rows
Shift + Spacebar Highlight Row CTRL + Spacebar Highlight Column Shift + Alt + -> Group Rows / Column Shift + Alt + <- UnGroup Rows / Column Ctrl + Minus Sign (-) Delete Selected Cells Shift + Ctrl + Plus SignInsert Blank Cells Alt + P + V + G View Gridlines Alt + P + V + H View Headings
