croom new

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
Thursday, October 18 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

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