Eclipse Integrated Systems Blog

Eclipse Integrated Systems has been serving the Bridgewater area since 1994, 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 Eclipse Integrated Systems blog for more useful tips.

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Monday, 21 May 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

Sign up for our Newsletter!

  • Company Name *
  • First Name *
  • Last Name *

      Latest News

      Eclipse Integrated Systems launches new website!

      Eclipse Integrated Systems is proud to announce the launch of our new website at www.eisystems.com. The goal of the new website is to make it easier for our existing clients to submit and manage support requests, and provide more information about our services for prospective clients.

      Read more ...

      Account login