MERIT Solutions Blog

MERIT Solutions has been serving the Chesapeake area since 1982, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

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 MERIT Solutions blog for more useful tips.

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, July 20 2018

Captcha Image

Tag Cloud

Security Tip of the Week Technology Best Practices Privacy Cloud Network Security Business Computing Hackers Malware Software Productivity Internet Hosted Solutions Managed IT Services Backup Business Management Mobile Devices google Computer Outsourced IT Business Microsoft Disaster Recovery Hardware communications VoIP Business Continuity IT Support Windows 10 Innovation IT Services Cybersecurity Email User Tips Efficiency Data Backup Tech Term Windows Cybercrime Mobile Device Management Server Ransomware Data Recovery Small Business Internet of Things Apps Mobility Managed IT Saving Money Data Productivity browser Law Enforcement Smartphone Operating System Virtualization BDR Money Telephone Systems Save Money Android Office 365 Passwords Cloud Computing Phishing Smartphones Hosted Solution Quick Tips Data Security Automation VPN IT Support Managed Service Provider Password Information Technology Holiday Recovery Network Chrome Communication Microsoft Office BYOD Facebook Government Alert Collaboration Two-factor Authentication Health Miscellaneous Wireless Computers Update Gadgets Risk Management Workplace Tips Unsupported Software Social Media Best Practice Vulnerability Budget Work/Life Balance Data Management Cost Management upgrade Social Data Breach Wi-Fi Application App Google Drive Hacking Avoiding Downtime User Error Data Protection Telephony Politics Gmail Cleaning USB Office tips Save Time Applications Private Cloud History Remote Computing Proactive IT Users Identity Theft Spam The Internet of Things Artificial Intelligence Flexibility Social Engineering Managed IT Services Shortcut Employer-Employee Relationship Streaming Media Router Firewall Tech Support search Blockchain Antivirus Current Events Audit Wireless Technology Compliance Personal Information iPhone Automobile Google Assistant Value Mobile Computing Transportation Redundancy Fraud Saving Time Travel Commerce Robot Office Computer Care Phone System Cortana End of Support Patch Management IT solutions Windows 10 Legal Encryption DDoS Project Management Wireless Charging MSP Excel Humor Television Disaster Big Data Data Storage Apple OneNote Education Vendor Management Networking Sports WiFi SaaS Going Green Management Samsung Bandwidth Content Filtering Data Loss Hacker Solid State Drive Battery eWaste Marketing Internet Exlporer HaaS Mobile Security Google Docs Devices Remote Monitoring Consultant Identity Safety Microsoft Excel Black Market Gifts Spyware PDF IT solutions Smart Technology Business Technology Language Professional Services Avoid Downtime server installation dvd "cannot install required files" Data Privacy File Sharing Shadow IT Text Messaging Document Management IT Management Windows 10s stock Computer Forensics Wasting Money Experience Nanotechnology Hard Drive Storage Credit Cards Edge WIndows Server 2008 Hard Disk Drive tweet PowerPoint Amazon Virus Tablets Video Games Root Cause Analysis Virtual Reality calculator Chromebook Scam FAQ Ciminal Laptop Uninterrupted Power Supply Twitter Wireless Internet Virtual Assistant control Proactive Music NFL Augmented Reality Business Intelligence Touchscreen Smart Tech Lifestyle Employer Employee Relationship Charger Outlook Touchpad WSJ Gamification Alexa for Business Exchange Websites Analytics Word Reputation Advertising Instant Messaging Managed IT Service Distributed Denial of Service altivista Connectivity Keyboard Legislation Computer Accessories Worker Commute iOS Memory Mobile Device SBS Data Theft Windows Ink Managing Stress Data storage compaq Content Filter Comparison Evernote intranet Regulation Computer Fan Students Chromecast Wearable Technology Computing Books Google Maps Administration Scalability Screen Mirroring hp Monitoring Hiring/Firing Specifications Unified Communications IT budget Sync Dark Web domain Analysis Software as a Service Colocation How To Meetings Sales Maintenance Hard Drives Cast Emails Benefits Financial Workers Adobe Files Settings Administrator Lithium-ion battery Unified Threat Management remote App store Retail Device Security Yahoo Financial Technology Bring Your Own Device Training Updates Identities Entertainment Licensing WannaCry Access Running Cable Upgrades Server 2008 Electronic Medical Records Relocation Conferencing Point of Sale HBO Webinar Ali Rowghani Printing Hybrid Cloud Company Culture Microsoft Word IoT HIPAA Mobile Trending Emergency Thank You Congratulations Worker CrashOverride Cache Monitors

Mobile? Grab this Article!

QR-Code dieser Seite

Recent Comments

Anna Jackson 5 SEO Tools To Get a Google-Eye View of Your Website
15 September 2017
Hello Randall! I was doing very important work but due to your subject I felt better to stay at you...
David Miller Not all project-management tools are right for all businesses
25 August 2017
All the points depicted by you in this blog is v.apt. I love the title of this blog because it says ...