(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
Sunday, 19 November 2017

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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