croom new

Eclipse Integrated Systems Blog

Tip of the Week: Functional Excel Features

Tip of the Week: Functional Excel Features

Spreadsheets are great for organizing information, but they aren’t particularly interesting to look at--especially if you aren’t using Microsoft Excel to the best of your ability. Today’s tip is dedicated to going over some of the more obscure Microsoft Excel tips and tricks that will help you stylize your spreadsheets and make them more dynamic.

Visible Zeros
Have you ever tried to enter in any number that begins with a zero into Excel? Chances are that you have, whether it’s for entering in serial numbers or dates. Excel will hide these zeros, making 000857 actually display as 857. This makes certain data inaccurate. You can fix this issue by adding a quotation mark in front of the number, keeping the zeros from being omitted from the result.

Create a Dropdown List
You can add a dropdown list to your spreadsheet so that it can showcase a lot of information in one particular cell. First, you have to click Validate in the Data tab, located in the header menu. Once you’re on the Settings page, you’ll see a menu labelled Allow. Next, select List and highlight the cells that make up the options you’d like in your dropdown menu. Once you’re done, click OK.

Accessing Tools on the Developer Tab
Depending on what you expect to use Excel for, you might have a need for more advanced capabilities for your spreadsheet. You can create option buttons, macros, and much more. These options can be found in the Developer tab, which will be hidden by default. First, you need to access the Excel menu at the top of your screen. You’ll select Preferences after this. From here, you select Ribbon & Toolbar. You’ll next see a list of the various options that you can add or remove from your Tabs. If you select Developer, you’ll see the tools that we just discussed.

Shading Every Other Row
Spreadsheets are difficult to look at when each row looks the same. You can add shading to the format to make it a little easier on the eyes. To do this, just highlight the area you want for this effect. You can use the shortcut Select All (Ctrl + A) to apply this effect to your entire sheet. In the Home tab, click on the Conditional Formatting option and select New Rule. You’ll then see a Style dropdown menu with the option for Classic. You’ll select Use a formula to determine which cells to format. Enter the formula =MOD(ROW(),2) and pick your desired color, and your spreadsheet should be striped quite nicely.

What are some of your favorite ways to take advantage of Microsoft Excel? Let us know in the comments.

Tip of the Week: Adding a Watermark to a Word Docu...
What Are the Differences Between Business Intellig...
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, February 22 2019

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

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