(415) 246-0101

Microtechs 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...

Related Posts



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

Captcha Image

Mobile? Grab this Article!


Tag Cloud

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