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