Excel Keyboard Shortcuts – Drag (Mouse)
Drag and Copy. | Ctrl Drag |
Drag and Cut. | Drag |
Drag and Insert. | Shift Drag |
Duplicate Worksheet. | Ctrl Drag |
Switch Position of Cells/Rows/Columns. | Ctrl Shift Drag |
Excel Keyboard Shortcuts – Charting
Inserts Chart in the Worksheet (using the selected data). | Alt F1 |
Inserts a ChartSheet with a Chart (using the selected data). | F11 |
Excel Keyboard Shortcuts – Find and Replace
Find and Replace Dialogue Box (Find Selected). | Ctrl F |
Display Find and Replace Dialogue Box (Replace Selected). | Ctrl H |
Find Next Match. | Shift F4 |
Find the Previous Match. | Ctrl Shift F4 |
Excel Keyboard Shortcuts – Conditional Formatting
Open Conditional Formatting Dialogue Box. | Alt O D |
Clear Conditional from Selected Cells. | Alt H L C S |
Clear Conditional from the Entire Worksheet. | Alt H L C E |