Top Excel Shortcuts For You!

 

 

 

Top Excel Shortcuts For You!

Ctrl + Shift + > - Increase font size

Ctrl + Shift + < - Decrease font size

Ctrl + ] - Select direct dependents (formula auditing)

Ctrl + [ - Select direct precedents

Ctrl + B - Toggle bold

Ctrl + I - Toggle italic

Ctrl + U - Toggle underline

Ctrl + 1 - Open Format Cells dialog

Ctrl + N - New workbook

Ctrl + O - Open workbook

Ctrl + S - Save workbook

Ctrl + P - Print dialog

Ctrl + Z - Undo

Ctrl + Y - Redo

Ctrl + C - Copy

Ctrl + X - Cut

Ctrl + V - Paste

Ctrl + F - Find

Ctrl + H - Replace

Ctrl + A - Select all

Alt + = - AutoSum

Ctrl + ; - Insert date

Ctrl + Shift + ; - Insert time

Alt + F1 - Create quick chart

F11 - Create chart in new sheet

Alt + A + M - Remove duplicates

Alt + N + V - Insert PivotTable

Ctrl + Arrow Keys - Navigate data

Shift + Space - Select row

Ctrl + Space - Select column

Bonus Tip: Use Ctrl + ]. to quickly trace which cells depend on your active cell!