Saturday, August 8, 2020

Formatting Cell Shortcuts in Excel


To do this action Press in Windows Press in Mac
Apply Date Format Ctrl+Shift+# ⌃ +⇧ +#
Apply General Format Ctrl+Shift+~ ⌃ +⇧ +~
Apply Number Format Ctrl+Shift+! ⌃ +⇧ +!
Apply Percentage Format Ctrl+Shift+% ⌃ +⇧ +%
Apply Scientific Format Ctrl+Shift+^ ⌃ +⇧ +^
Apply Time Format Ctrl+Shift+@ ⌃ +⇧ +@
Apply or Remove Bold Formatting Ctrl+B ⌘ +B
Apply or Remove Italic Formatting Ctrl+I ⌘ +I
Apply or Remove Strikethrough Formatting Ctrl+5 ⌘ +⇧ +X
Apply or Remove Underline Ctrl+U ⌘ +U
Check Spelling F7 Fn+F7
Copy Formula from above Cell Ctrl+' ⌃ +'
Display the Quick Analysis Options Ctrl+Q
Edit Active Cell F2 ⌃ +U
Enter Current Date Ctrl+; ⌃ +;
Enter Current Time Ctrl+Shift+; ⌘ +;
Fill Down from Cell Above Ctrl+D ⌃ +D
Fill Right from Cell Left Ctrl+R ⌃ +R
Format Fonts in Format Cells Dialog Ctrl+Shift+F ⌃ +⇧ +F
Insert a Note Shift+F2 Fn+⇧ +F2
Insert Table Ctrl+T ⌃ +T
Insert Threaded Comment Ctrl+Shift+F2
Open Delete Dialog to Delete Cells Ctrl+- ⌘ +-
Open Format Cells Dialog Ctrl+1 ⌘ +1
Open Insert Dialog to Insert Cells Ctrl+Shift++ ⌘ +⇧ ++
Open Paste Special Dialog Ctrl+Alt+V ⌃ +⌘ +V
Open the Insert Hyperlink Dialog Ctrl+K ⌘ +K
Apply Outline Borders to Cells Ctrl+Shift+& ⌘ +⌥ +0
Remove Outline Border to Selected Cell(s) Ctrl+Shift+_ ⌘ +⌥ +_
Show or Hide Objects Ctrl+6 ⌃ +6
Show or Hide Outline Symbols Ctrl+8 ⌃ +8
Toggle Formulas On and Off Ctrl+` ⌃ +`



For More Shortcuts (Click on the links below):

Excel Ribbon Tab Shortcuts for Windows

Shortcuts to Make Selections in Excel

Inside the Ribbon Shortcuts in Excel

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

Excel Cell Navigation Shortcuts For Mac & Windows

Formula Shortcuts For Mac & Windows



No comments:

Post a Comment