M.s excel shortcuts, Formulas and forms for Computer science
R.S.RAGHAW
R.S.RAGHAW

M.s excel shortcuts, Formulas and forms for Computer science

XLSX (11 KB)
3 pages
943Number of visits
Description
In this file you can find the shortcuts key of Ms Excel.
20 points
Download points needed to download
this document
Download the document
Preview3 pages / 3
Download the document

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 & Auditing = ( Equal Sign )

ALT + Tab Switch Program Shoft + F3 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

Formulas & Auditing Start a formula

no comments were posted
Download the document