Workbook Tip: Use Ctrl + W to quickly close files without exiting Excel!
πΉ Ctrl + W - Close current workbook
πΉ Ctrl + N - New workbook
πΉ Ctrl + O - Open workbook
πΉ Ctrl + S - Save workbook
πΉ Ctrl + P - Print dialog
πΉ Ctrl + E - Flash Fill
πΉ Alt + = - AutoSum
πΉ Ctrl + ; - Insert current date
πΉ Ctrl + Shift + ; - Insert current time
πΉ Ctrl + 1 - Format Cells dialog
πΉ Ctrl + T - Create table
πΉ Ctrl + Space - Select entire column
πΉ Shift + Space - Select entire row
πΉ Ctrl + Arrow Keys - Navigate data edges
πΉ Ctrl + Shift + L - Toggle filters
πΉ Alt + N + V - Insert PivotTable
πΉ Alt + A + M - Remove duplicates
πΉ Ctrl + D - Fill down
πΉ Ctrl + R - Fill right
πΉ Ctrl + - (Minus) - Delete selection
πΉ Ctrl + Shift + + (Plus) - Insert cells
πΉ Alt + E + S + V - Paste values
πΉ Alt + H + O + I - AutoFit column width
πΉ F2 - Edit active cell
πΉ F4 - Repeat last action/Toggle references
πΉ F9 - Calculate worksheets
πΉ Shift + F3 - Insert function
πΉ Ctrl + F3 - Name Manager
πΉ Alt + F1 - Create embedded chart
πΉ F11 - Create chart in new sheet
Workbook Tip: Use Ctrl + W to quickly close files without exiting Excel!
Follow π
Comments
Post a Comment