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

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
Saturday, 18 November 2017

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

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