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 Hide Rows in Excel Taylor Karl / Monday, November 22, 2021 / Categories: Resources, Microsoft Office, Training Trends 3194 0 How to Hide Rows in Excel Excel can seem like a foreign language to even the most well-versed professionals. Allow us to be your translator! Here are the steps to Hiding and Unhiding Rows in Excel. Select the rows you want to hide: You can complete this a number of different ways: 1. Select the number, click down on your mouse and drag the mouse down. 2. Select the number, hit the shift + down OR up arrow until you get to the row you desire. 3. Lastly, you can click the number, hit the shift button on your keyboard, and then click the numbers with your mouse you want to hide. This option is great when the rows you would like to hide are scattered through the sheet. Click the Home Tab: This section resides right next to your "File" tab in the top right corner of the page. Head to the Cells Section: Our "Cells" section is located between your "Styles" and "Editing" Sections are displayed below. Click Format and move your courser over the Hide/Unhide option Select Hide Rows: Hide & Unhide selection is under the "Visibility" sub-category Results: Before: You can see the rows that you want to hide are still selected and showing in gray. After: You can see Row 4-6 are no longer visible Short and Sweet Some professionals want to speed up this process and what better way to do that than with a keyboard shortcut? The Keyboard Shortcut for PC Users is CTRL + 9 and for you Mac Users it would be Command + 9. Simply select which rows you would like to hide and then hit the keys listed above for your device. Then boom your rows are now hidden! For more Excel tips head to our Blog or you can venture to our Webinar Page to see what amazing events we have slated for the future! Submit your email below to download our free 49-page eBook, Top 20 Office Productivity Tips Print Tags Microsoft Excel Excel Hacks Microsoft Excel How To Series Excel Tips Related articles Excel Certification: What It Is and Why It Matters in the Professional World Microsoft SC-900 vs CompTIA Security+: All You Need To Know What’s the Difference: Power BI, Power Query, & Power Pivot Leading Through Change: Embracing AI and Automation in Your Organization Microsoft Power BI Vs Tableau: A Comprehensive Guide