100+ Excel Keyboard Shortcuts – 10x Your Productivity

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

Leave a Comment