Heart of Texas Network Consultants Blog

Tip of the Week: 3 Better Ways To Use Excel

Tip of the Week: 3 Better Ways To Use Excel

Microsoft Excel is more or less synonymous with spreadsheet creation. However, even power users may not know all the tricks that are hidden in the program that can help them save significant time. For this week’s tip, we’ll go over some Excel shortcuts that you may not have known about.

Adding the Same Text to Multiple Cells
It’s a hassle that every Excel user has faced: the same text needs to be inserted into many cells. Fortunately, there’s a simpler way to go about doing this than one cell at a time. If you highlight the cells that need the text entered before typing the text, and press Ctrl and Enter instead of just Enter, your selected cells will have that text added in.

Auto-Sum Shortcut
Excel can naturally be used as a quick-adding calculator, but a quick shortcut can make that easier. Highlighting the cells, you need to add together before pressing Alt and = will give you final sum.

Data Sorting, Made Easier
In those cases where you need your data to be sorted by a particular variable, Microsoft gives you the means to do so in their Auto Filter. Once your spreadsheet is populated with your data, you can select the columns to be filtered by selecting the top rows. Once you’ve done so, click Data. You will then see options for Filter and subsequently, Auto Filter. This adds a drop-down menu to each column, allowing you to sort the entire spreadsheet by that data in that column.

What are your most-used Excel shortcuts? Tell us in the comments, and check back in to the Heart of Texas Network Consultants blog for more useful tips.

Worry Less With Hardware-as-a-Service
Is It A Good Idea To Bait A Phishing Scam?
 

Comments

No comments made yet. Be the first to submit a comment
Guest
Already Registered? Login Here
Guest
Thursday, July 18 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Data Management Spam Outsourced IT Vulnerability Managed Service Provider Artificial Intelligence Telephone Systems Windows 8 Disaster Recovery Health Cloud Malware Bring Your Own Device The Internet of Things Cloud Computing Small Business Hardware Information Technology Shortcut PowerPoint Search Android BDR Mobile Computing Customer Relationship Management Browser Mobile Office Work/Life Balance Education Managed IT Services Cybercrime Proactive IT Internet of Things Going Green Current Events OneNote Quick Tips User Tips Windows Social Apps Business Computing BYOD Efficiency Miscellaneous Avoiding Downtime Virtualization Save Money Mobility Ransomware Data Security Managed IT Services Bandwidth Information Email Network Privacy Remote Computing Data Backup Microsoft Office Applications Hackers Passwords Google Encryption Software Tech Support Gmail Best Practice Innovation Unsupported Software Tip of the Week Microsoft Users Computers Productivity WiFi Cybersecurity Phishing App Office Tips Wi-Fi IT Support Update Mobile Devices Humor Antivirus Chrome Office Internet Wireless Marketing Tech Term Workplace Tips Business IT Services History Business Management Laptop Windows 10 Maintenance Alert Best Practices Smartphone IT Support Application Backup Blockchain Technology Upgrade Social Media Communication Collaboration Saving Money Managed Service Automation Money Operating System Hacking Vendor Management Big Data User Error Wireless Technology iPhone Business Continuity Gadgets Lithium-ion battery Risk Management Cost Management Personal Information Facebook Windows 10 communications Productivity IT Solutions Security Holiday Mobile Device Management Computer Hosted Solutions Data Recovery Network Security Office 365 Password Router Google Drive Tablet Networking USB Unified Threat Management Employer-Employee Relationship Government Two-factor Authentication VoIP Data Printer Law Enforcement Server Hard Drives Smartphones