رتبها

50+ MS Excel Shortcuts for
💻 Windows
🖥️ macOS
⇩

Symbols used in this 🧵
💻 Windows OS
🖥️ macOS
⌘ Command key in macOS
⇧ Shift key in macOs
⌃ Control key in macOS
⌥ Option key in macOS

➊ Workbook Related
➀ Open New Workbook
💻 CTRL+N
🖥️ ⌘+N
➁ Open Existing Workbook
💻 CTRL+O
🖥️ ⌘+O
➂ Save Workbook
💻 CTRL+S
🖥️ ⌘+S
➃ Save As
💻 F12
🖥️ ⌘+⇧+S / F12
➄ Close Workbook
💻 CTRL+W
🖥️ ⌘+W

➅ Print Workbook
💻 CTRL+P
🖥️ ⌘+P
➆ Undo Action
💻 CTRL+Z
🖥️ ⌘+Z
➇ Redo Action
💻 CTRL+Y
🖥️ ⇧+⌘+Z
➈ Find in a Workbook
💻 CTRL+F
🖥️ ⌃+F
➉ Find & Replace
💻 CTRL+H
🖥️ ⇧+⌘+H
➀➀ Check Spelling
💻 F7
🖥️ F7

➋ Copy/Paste
➀ Copy
💻 CTRL+C
🖥️ ⌘+C
➁ Cut
💻 CTRL+X
🖥️ ⌘+X
➂ Paste
💻 CTRL+V
🖥️ ⌘+V
➃ Paste Special
💻 CTRL+ALT+V
🖥️ ⌘+⌃+V

➌ Cell Formatting
➀ Format Cell
💻 CTRL+1
➁ Bold
💻 CTRL+B or, CTRL+2
🖥️ ⌘+B
➂ Italic
💻 CTRL+I or, CTRL+3
🖥️ ⌘+I
➃ Underline
💻 CTRL+U or, CTRL+4
🖥️ ⌘+U
➄ Strike-Through
💻 CTRL+5
🖥️ ⇧+⌘+X

➅ Show Border
💻 CTRL+Shift+&
🖥️ ⌘+⌥+0
➆ Remove Border
💻 CTRL+Shift+_
🖥️ ⌘+⌥+-
➇ Outline Symbols
💻 CTRL+8
🖥️ ⌃+8
➈ Apply Time Format
💻 CTRL+Shift+@
🖥️ ⇧+⌃+@

➉ Apply Comma Separator Format
💻 CTRL+Shift+!
🖥️ ⇧+⌃+!
➀➀ Apply Currency Format
💻 CTRL+Shift+$
🖥️ ⇧+⌃+$
➀➁ Apply Date Format
💻 CTRL+Shift+#
🖥️ ⇧+⌃+#

➀➂ Apply Percentage Format
💻 CTRL+Shift+%
🖥️ ⇧+⌃+%
➀➃ Apply Exponential Number Format
💻 CTRL+Shift+^
🖥️ ⇧+⌃+^
➀➄ Apply General Number Format
💻 CTRL+Shift+~
🖥️ ⇧+⌃+~

➍ Cell Filling
➀ Fill Cells Down
💻 CTRL+D
🖥️ ⌘+D
➁ Fill Cells Right
💻 CTRL+R
🖥️ ⌘+R
➂ Insert Cells
💻 CTRL+Shift+=
🖥️ ⇧+⌃+=
➃ Delete Cells
💻 CTRL+-
🖥️ ⌘+-

➄ Insert Hyperlink
💻 CTRL+K
🖥️ ⌘+K
➅ Enter current date
💻 CTRL+;
🖥️ ⌃+;
➆ Enter current time
💻 CTRL+Shift+:
🖥️ ⌘+;

➎ Selection/Hide
➀ Select Entire Sheet
💻 CTRL+A
🖥️ ⌘+A
➁ Select Entire Row
💻 Shift+Spacebar
🖥️ ⇧+Spacebar
➂ Select Entire Column
💻 CTRL+Spacebar
🖥️ ⌃+Spacebar
➃ Extend selection by one cell
💻 Shift+↑/→/↓/←
🖥️ ⇧+↑/→/↓/←

➄ Selection to the last nonblank cell
💻 Shift+CTRL+↑/→/↓/←
🖥️ ⇧+⌘+↑/→/↓/←
➅ Selection to the beginning of the column
💻 Shift+Page up
➆ Selection to the end of the column
💻 Shift+Page down

➇ Selection to the beginning of the row
💻 Shift+Home
🖥️ ⇧+Fn+←
➈ Selection to the end of the row
💻 Shift+End
➉ Selection to the beginning of the sheet
💻 CTRL+Shift+Home
🖥️ ⇧+⌃+Fn+←

➀➀ Selection to the last cell used on the sheet
💻 CTRL+Shift+End
🖥️ ⇧+⌃+Fn+→
➀➁ Hide Column
💻 CTRL+0
🖥️ ⌘+)
➀➂ Unhide Column
🖥️ ⇧+⌘+)
➀➃ Hide Row
💻 CTRL+9
🖥️ ⌘+(
➀➄ Unhide Row
🖥️ ⇧+⌘+(

Hey 👋
I am a Tech Writer, Educator, and Mentor from India 🇮🇳, here sharing
✅ Tutorials
✅ Tricks
✅ Career Tips
✅ Cheat Sheets
✅ Interview Questions
✅ Roadmaps
on
➠ Web Development
➠ Data Structures and Algorithms
➠ Databases
Thanks for reading. 🙏

التصنيفات

المزيد من هذا الكاتب

مواضيع ذات صلة

الأكثر اعجابا

التصنيفات

المزيد من هذا الكاتب

مواضيع ذات صلة

الأكثر اعجابا

فك الثريد