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 Azure Dynamics Office Power Platform PowerShell Security SharePoint SQL Server Teams Windows Client Windows 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
How to Protect Cells in Microsoft Excel Taylor Karl / Monday, June 6, 2022 / Categories: Resources, Microsoft Office 2775 0 How to Protect Cells in Microsoft Excel Select the cells you want to lock: You can complete this in several ways. Click the first cell, then hold the CTRL button on your keyboard down, and continue clicking on the cells you want to select. This option is perfect for cells scattered throughout your sheet. If your cells are grouped together, you can select them by clicking on the first cell you want to protect and dragging your mouse in the direction of the other cells until they are all highlighted in gray. Select the Home tab: This section resides right next to your "File" tab in the top right corner of the page Head to the Alignment Section and click the small arrow to open the Format Cells popup window: This is completed by hitting the 90-degree angle with the arrow inside of it as pictured below. Select the Protection tab: Listed as the last tab on your pop-up screen. Select the Locked check box, and then click OK to close the popup: This will result in all the cells you selected to now be protected. Just like that, you are done! Still, looking for more Excel tips? Head to our blog for more instructional articles or you can venture to 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 30 Most Useful Keyboard Shortcuts in Microsoft Excel How to Create Drop Down Lists in Microsoft Excel