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
-------------------------------------------------------------------------