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
Monday, December 17 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

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