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.

e-max.it: your social media marketing partner
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Monday, 23 October 2017
If you'd like to register, please fill in the username, password and name fields.

Tag Cloud

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

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 ...