croom new

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

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

Blog Archive

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