Excel Tutorial #19: Keyboard shortcuts ctrl key shortcuts

#ExcelTutorial #HowtoExcel #ExcelBestPractice #01 Work with files in Backstage view #02 Home Tab #03 Math - anywhere #04 Commands #05 Keyboard excel shortcuts #06 Excel spreadsheet #07 Basic math in Excel #08 How to create a column title #09 Automatic typing #10 Functions and Formulas #11 Rules and Formatting #12 vlookup #13 Sparklines - tiny charts #14 Automatic Tables #15 if function #16 How to create a chart #17 Dates by using formulas #18 Payments and savings #19 Keyboard shortcuts ctrl key shortcuts #20 Keyboard shortcuts alt key shortcuts ------------------------------------------------------------------------- Quick Reference Card ------------------------------------------------------------------------- To do this Press New workbook CTRL+N Save CTRL+S Undo CTRL+Z Redo CTRL+Y Cut CTRL+X Print CTRL+P Open files CTRL+O Find text CTRL+F Copy CTRL+C Paste all CTRL+V Paste special CTRL+ALT+V Close CTRL+W Exit Excel ALT+F4 Fill right CTRL+R Fill down CTRL+D Insert AutoSum ALT= Fill current entry CTRL+ENTER F2 Edit Formula Expand Formula Bar CTRL+SHIFT+U View formulas CTRL ` Change reference type F4 Cancel entry ESC Move one cell Arrow keys Move to edge of range CTRL+Arrow Move to last cell on worksheet that contains data CTRL+End Move to beginning of worksheet CTRL+Home Go To dialog box CTRL+G Move one screen down Page Down Move one screen up Page Up Move one screen to the right ALT+Page Down Move one screen to the left ALT+Page Up Move to next worksheet CTRL+Page Down Move to previous worksheet CTRL+Page Up Extend selection by one cell SHIFT+Arrow keys Extend selection to end of row or column CTRL+SHIFT+Arrow keys Extend selection to end of data CTRL SHIFT+END Extend selection to Cell A1 CTRL+SHIFT+HOME Select all CTRL+A Select row SHIFT+Spacebar Select column CTRL+Spacebar Select only the visible data after hiding rows or columns ALT+; Insert cells, rows, or columns CTRL+SHIFT+Plus sign Delete cells, rows, or columns CTRL+Minus sign Hide rows CTRL+9 Hide Columns CTRL+Zero Insert new worksheet SHIFT+F11 -------------------------------------------------------------------------