(703) 288-9767    NTC Store
NTConnections Blog

NTConnections has been serving the Reston area since 2003, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Making Your Excel Use Easier

When it comes to making a spreadsheet, Microsoft Excel is the go-to program for many users. However, many of these users spend much more time creating and formatting these spreadsheets than they have to. For today’s tip, we’ll outline some experience-improving shortcuts that can improve how you use Excel.

Auto Sum Shortcut
You can use Excel as a quick-adding calculator. This can be made even easier with a quick shortcut. Once you’ve highlighted all the cells you’re trying to total up, pressing Alt and = will give you the final result.

Multiple Cells with the Same Text
We’ve all been there--arduously pasting the same text into cell after cell. Fortunately, there’s a shortcut that will let you do the same thing. Again, after highlighting all the cells that need the same text, you simply type the desired input, but press Ctrl and Enter rather than just hitting the Enter button on its own.

Speedy Data Sorting
Sometimes, we need to order the data in a spreadsheet by a particular variable. The Microsoft Auto Filter is a handy way to do so. Once your data is in the spreadsheet, you can select the columns you want to Auto Filter by clicking the top rows. Once that’s attended to, click Data. You will then see the option for Filter and then Auto Filter. This adds drop-down option menus to the top rows of each column, allowing you to sort them based on that column’s data, alphabetizing or grouping the data by its value.

What are your favorite Excel shortcuts? Let us know in the comments, and be sure to come back to the NTConnections blog for more handy tips and trick!

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Thursday, 21 September 2017

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Security Tip of the Week Technology Best Practices Cloud Privacy Hackers Business Computing Productivity Microsoft Backup Malware Hosted Solutions Internet Efficiency Mobile Devices IT Support Google Business Miscellaneous IT Services Managed Service Provider Server Workplace Tips VoIP Network Innovation Data Disaster Recovery Business Continuity Upgrade Hardware Email Windows Save Money Saving Money Business Management Computer Software Mobile Device Management Communication Virtualization Smartphones Network Security User Tips Windows 10 Microsoft Office Browser Smartphone WiFi Hacking Holiday Android BYOD Social Media Operating System Computers Mobile Computing Cybercrime Chrome IT Solutions Managed IT Services Application communications Apple Outsourced IT Office Budget Marketing The Internet of Things Big Data Quick Tips Small Business Automation Proactive IT Information Technology Remote Monitoring Avoiding Downtime Passwords Collaboration Health Going Green VPN Remote Computing Employer-Employee Relationship Alert spam Managed IT Services Ransomware Recovery Social Engineering Wireless Technology App Mobility User Error Bring Your Own Device Managed IT Vendor Management Save Time Firewall iPhone Gadgets Compliance Networking Telephone Systems Gmail Lithium-ion battery Private Cloud PowerPoint Excel Mouse IT Support Phone System Downtime Antivirus History Office 365 Tablet Data Backup Retail Memory Analytics Search Bandwidth Best Available Intranet People Programming Office Tips Network Congestion Hard Drives Facebook Public Cloud How To Humor Physical Security DDoS IT Consultant BDR Unsupported Software Statistics Robot Google Drive Environment Saving Time Document Management Website Outlook Risk Management Cloud Computing Safety Law Enforcement Online Currency Flexibility Content Filtering Solid State Drive Redundancy Meetings Printer Administration HaaS Fax Server Black Market Entertainment Windows 10 Data Management Running Cable Current Events Value Business Owner Internet of Things Skype Maintenance Unified Threat Management Data Storage Router Mobile Office Internet Exlporer Data storage Customer Relationship Management Cybersecurity Biometrics Debate Bluetooth Sports Windows 7 Computer Accessories Monitor Botnet eWaste Internet exploMicrosoft Tablets Root Cause Analysis Notifications Data Warehousing Touchscreen USB YouTube Regulations Cameras Reputation Patch Management Travel Wearable Technology Advertising Video Surveillance Data loss Consultant IT Management Trending Social Artificial Intelligence Servers Education NarrowBand Printer Server Customers Best Practice IT Plan Social Networking Flash Piracy Phishing Worker Commute Chromecast Hybrid Cloud Analyitcs Apps User HIPAA Sync Licensing Settings Laptop Spam Blocking Distributed Denial of Service Samsung Twitter Software Tips Virtual Desktop Touchpad Telephony IT service Human Resources Relocation SaaS Vulnerability Crowdfunding Virtual Reality Company Culture Training Windows 8.1 Update Uninterrupted Power Supply Data Security Start Menu Domains Computer Fan Government IaaS Audit Money Bloatware Customer Service Cleaning Applications HBO Mobile Files Windows Media Player FENG Screen Mirroring Entrepreneur Tech Support Frequently Asked Questions Professional Services Hiring/Firing Colocation Hacker Print Server Workers WIndows 7 Cast Cost Management Two-factor Authentication Shadow IT Tip of the week Hosted Solution Tools Wireless Computing Infrastructure Science Computer Repair OneNote Managing Stress Streaming Media Instant Messaging Net Neutrality Shortcut Windows Server 2008 Virus Word SharePoint End of Support LinkedIn Windows 8 Encryption Business Intelligence IBM Work/Life Balance Emergency Webinar Worker Supercomputer Content IT solutions Rootkit Video Games Knowledge Audiobook Netflix Scam Data Recovery Charger Scalability Politics Transportation Computer Care How to webinar Benefits PDF Loyalty Keyboard Conferencing Windows 10s Smart Technology Battery Experience Two Factor Authentication Assessment Music Productivity Password Television Wi-Fi Troubleshooting Electronic Medical Records Techology Public Computer Users Employer Employee Relationship Legal Data Breach Automobile Books Emails CrashOverride Mobile Device