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
Sunday, 21 January 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

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