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

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Thursday, December 13 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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