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

Mobile? Grab this Article!

QR-Code dieser Seite

Recent Comments

No comments yet.