Out of the Box Solutions 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...


No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Saturday, April 20 2019

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

Tip of the Week Security Technology Best Practices Business Computing Network Security Productivity User Tips Privacy Tech Term Internet Efficiency Smartphones Communication Microsoft Data Google Innovation Hardware Email Cybersecurity Windows 10 IT Support Cloud Users Malware Mobile Device Browser Android Mobile Devices Passwords Business Small Business IT Services Business Management Communications Collaboration Ransomware Network Wireless Holiday Hackers Software Workplace Tips Bandwidth Applications Outsourced IT Managed IT services Backup Data Backup Saving Money Managed IT Services Wi-Fi Data recovery Internet of Things VoIp Marketing Apps Cloud Computing Business Intelligence Social Media Blockchain Hosted Solutions Information Employer-Employee Relationship Networking Gmail Microsoft Office Access Control Connectivity Automation Medical IT Gadgets Facebook Chrome Paperless Office Smartphone Artificial Intelligence Healthcare Virtual Assistant Password Cost Management Analytics Managed Service Mobility Wireless Charging Managed IT Service Remote Computing Data Security Patch Management Compliance Virtualization Computer Net Neutrality Office VPN BDR G Suite Data Management Office 365 Remote Monitoring and Management Computers Cortana Tech Terms Save Money Upgrade IT budget SSD A.I. Data Breach Time Management Document Management Telecommute Amazon Eliminating Downtime Physical Security Workers Dark Web Payment Hard Drive Value Hybrid Cloud Specifications Dongle Paper Wearables Lead Generation Network Attached Storage Operating System Company Culture Voice over IP Electronic Health Records Staff Analysis Certification Battery Movies Sales Authentication Maintenance BYOD eCommerce Laptop Technology Tips Millennials Error instant Messaging Processors Cables Ink SaaS Managing Stress Troubleshooting Health Router Twitter Tablet Authorization Chrome OS Digital Data loss Conferencing Plug-In Wireless Internet Online Shopping Streaming Media Business Technology Vulnerabilities Vulnerability Machine Learning Database Voice over Internet Protocol Government PowerPoint GDPR Environment Update Websites Internet Explorer Training IT Management Inventory Unified Communications Excel Spam Employees Proactive IT Help Desk Backup and Disaster Recovery Downloads Touchscreen Cryptocurrency Spyware Cybercrime Big Data Sports Telecommuting Personal Information WannaCry Server Management e-waste Outlook Safety Threat Tip of the week Security Cameras Server Data Protection RAM Knowledge Human Resources Edge Virus Content Filtering Business Continuity Settings Hard Drives Trends Phishing Microsoft Office 365 HP Tactics Storage E-Commerce HIPAA disposal Bring Your Own Device Comparison Profitability Printing User Tip Reporting Word Mobile Security Microsoft Teams Telephony Miscellaneous Employee-Employer Relationship Antivirus Alert Printers Quick Tips Regulation Disaster Recovery Solid State Drive Windows 7 Hard Disk Drive