Excel Shortcuts (Data Analysis)

ShortcutAction
Ctrl + TConvert range to Table
Ctrl + Shift + LToggle Filters
Alt + =AutoSum
Ctrl + SpaceSelect entire column
Shift + SpaceSelect entire row
Ctrl + Arrow KeysJump to edge of data region
Ctrl + Shift + → / ↓Select to last filled cell (row/column)
F4Repeat last action / Toggle $ in references
Ctrl + 1Format Cells
Ctrl + `Show/Hide formulas
Alt + H, O, IAuto-fit column width
Alt + A, MRemove Duplicates
Alt + F1Insert chart from selection
Ctrl + Shift + +Insert row/column
Ctrl + –Delete row/column

Share on :

Social Share

Recent Post

© 2024 All rights reserved by Go1digital.com