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

Popular posts from this blog

πŸ›°️ *Apple’s iOS 18 to Introduce Satellite Messaging*

πŸŽ™ Apple unveiled a brand-new state-of-the-art studio space in LA