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
Tuesday, 16 January 2018

Captcha Image

Tag Cloud

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