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. your social media marketing partner


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

Captcha Image

Tag Cloud

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

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