Adobe Apple AWS CertNexus Check Point Cisco Citrix CMMC CompTIA Dell Training EC-Council F5 Networks Google IBM ISACA ISC2 ITIL Lean Six Sigma Oracle Palo Alto Python PMI Red Hat Salesforce SAP SHRM Tableau VMware Microsoft 365 AI Applied Skills Azure Copilot Dynamics Office Power Platform Security SharePoint SQL Server Teams Windows Client/Server
Agile / Scrum AI / Machine Learning Business Analysis Cloud Cybersecurity Data & Analytics DevOps Human Resources IT Service Management Leadership & Pro Dev Networking Programming Project Management Service Desk Virtualization
AWS Agile / Scrum Business Analysis CertNexus Cisco Citrix CompTIA EC-Council Google ITIL Microsoft Azure Microsoft 365 Microsoft Dynamics 365 Microsoft Power Platform Microsoft Security PMI Red Hat Tableau View All Certifications
30 Most Useful Keyboard Shortcuts in Microsoft Excel Taylor Karl / Monday, June 13, 2022 / Categories: Resources, Microsoft Office, Training Trends 4887 0 Excel can pose a challenge for some professionals, and if you work heavily with workbooks, you understand how frustrating it can be to get started. We decided to find the 30 most useful keyboard shortcuts for Excel to kickstart your productivity and make your job a bit easier. We have listed both Mac and Windows versions of each shortcut if they differ between operating systems. Shortcuts can be created and altered on most Mac computers. If you need help creating Excel shortcuts on your Mac, visit our How to Autofit in Excel blog for instructions. Let's jump in! To edit a cell F2 Mac: Control + U To copy and paste cells Ctrl + C, Ctrl + V Mac: Command + C and Command + V To italicize and make the font bold Ctrl + I, Ctrl + B Mac: Command + I and Command + B To center align cell contents: Alt + H + A + C Mac: Command + E Align left Alt + H, A, L Mac: Command + R (you must be in edit mode, meaning clicked into the cell or select multiple cells) Align right Alt + H, A, R Mac: Command + L (you must be in edit mode, meaning clicked into the cell or select multiple cells) To fill color: Alt + H + H To add a border: Alt + H + B Mac: Command + Option + 0 To remove outline border: Ctrl + Shift + _ Mac: Command + Option + _ To Strikethrough: Ctrl + 5 (same keyboard buttons for both Windows and Mac users) To select the entire column: Ctrl + Space (same keyboard buttons for both Windows and Mac users) To delete a column: Alt+H+D+C Mac: Control + - To group rows or columns: Alt + Shift + Right arrow Mac: Command + Shift + K To ungroup rows or columns: Alt + Shift + Left arrow Mac: Control + Shift + J Insert Date: Ctrl + Mac: Control + Shift +: Insert Time: Ctrl +: Mac: Control + Shift +: Insert Chart: Alt + F1 Save As: F12 Mac: Command + ⇧ + Shift + S Select all cells in column: Ctrl + Shift + ↓ (same keyboard buttons for both Windows and Mac users) Duplicate Object: Control + D (same keyboard buttons for both Windows and Mac users) Go to next workbook Ctrl + Tab Mac: Command + ` (accent grave) Go to previous workbook Ctrl + Shift + Tab Mac: Command + shift + ` (accent grave) Protect sheet Alt + R, P, S Move one-word right Ctrl + → Mac: ^ + → Move one word left Ctrl + ← Mac: ^ + ← Copy formula from cell above (formula is exact copy) Ctrl + ' Wrap text Alt + H, W Delete to end of line: CTRL Delete Mac: ^ + Delete Close a workbook: Ctrl-W Mac: Command + W Cancel Entry: Esc (same keyboard buttons for both Windows and Mac users) Still, looking for more Excel tips? Head to our blog for more instructional articles, or you can visit our webinar page to see our schedule of upcoming events. Submit your email below to download our free 49-page eBook, Top 20 Office Productivity Tips Print Tags Excel Excel Hacks How To Series Excel Tips Related articles Microsoft Excel Tutorial | Date Functions & Example Formulas Text Functions & Formula Examples | Microsoft Excel Tutorial How to Delete a Row in Excel with a Keyboard Shortcut How to Protect Cells in Microsoft Excel How to Create Drop Down Lists in Microsoft Excel