Our Most Popular Managed Services

If you need help deciding what services are best for your business let us know.


 Popular Services
 (502) 212-2525



Triad IT 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 1

MaryFSolomon on Saturday, 20 October 2018 02:52

This is one of the best articles you have written ever and I love to read these functional excel features. I know how to get the best essay writer and it was a great experience for me as a part of this platform.

This is one of the best articles you have written ever and I love to read these functional excel features. I know how to get [url=https://www.bestessay.org/]the best essay writer[/url] and it was a great experience for me as a part of this platform.
Already Registered? Login Here
Tuesday, December 11, 2018
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Sports Wi-Fi Movies Wireless Charging Compliance Spyware Comparison Wireless Remote Computing Bring Your Own Device Mobile Devices Small Business Data loss Amazon Telephony Virtualization Data Backup Laptop Browser eCommerce Business VPN A.I. Productivity Tech Terms Edge Cost Management Internet of Things Thank You Hard Drive Tip of the Week Physical Security Blockchain Alert HP Business Technology Computer Ink Bandwidth Router Microsoft HIPAA Cybersecurity Mobile Security Document Management Innovation Network Cloud Computing Microsoft Office Save Money Business Management Apple WannaCry Spam Paper RAM Technology Tips Cloud Network Attached Storage Virus disposal Downloads Social Media Business Computing Employer-Employee Relationship Managing Stress Threat Technology User Security Backup Battery Data Breach Best Practices Email Hosted Solutions Networking Virtual Assistant User Tips Security Apps Maintenance Cybercrime Reporting Trends Managed IT Service Staff Processors Information Business Intelligence Efficiency Collaboration Miscellaneous Office Vulnerability Data Protection Saving Money Office 365 Smartphones Hackers Internet Explorer Ransomware Online Shopping Marketing Hardware Backup and Disaster Recovery Connectivity Analysis Law Enforcement Tech Term Android Internet Analytics Applications Settings Automation Sales Government Software Tip of the week SSD Big Data Millennials Phishing Hybrid Cloud Excel Content Filtering How To Plug-In iPhone Malware Cables Passwords Congratulations Voice over Internet Protocol BDR Conferencing Database Telecommuting IT budget Holiday User Tip IT Support Patch Management Outsourced IT Gmail Facebook Network Security Artificial Intelligence Lead Generation Machine Learning WiFi Managed Service Communications Workers Remote Monitoring and Management Tablet Regulation Tactics File Sharing Proactive IT Server Management Operating System Hard Drives Environment Value Smartphone Data PowerPoint Websites Specifications Data recovery Chrome Gadgets Inventory VoIp Managed IT services IT Management Users Password Google Voice over IP Paperless Office Digital Twitter IT Services Privacy Communication Knowledge Antivirus Data Management Microsoft Teams Server Unified Communications Dongle Telecommute Safety e-waste Printing Managed IT Services Windows 10 Streaming Media Company Culture Computers G Suite Workplace Tips Cortana

Newsletter Sign Up