Our Blog: Stuff we think you should know

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.

Why a Proactive Stance is Best for Your IT
What Are the Differences Between Business Intellig...
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, July 19 2019

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

Tip of the Week Security Best Practices Technology Cloud Privacy Business Email Hackers User Tips Microsoft Business Computing Malware Hosted Solutions Computer Network Security Google Productivity Software Internet Tech Term Communication Data Small Business Ransomware Backup Mobile Devices Efficiency IT Services Workplace Tips Hardware Cloud Computing Windows 10 Smartphone Microsoft Office Android Saving Money Data Recovery IT Support Office 365 Upgrade Productivity Facebook Browser Business Continuity Users Social Media Information Managed IT Services Gmail Windows Data Management Data Backup Server Phishing Internet of Things Word Innovation Managed IT Services Mobile Device Miscellaneous Disaster Recovery Smartphones Outsourced IT App Passwords Windows 10 Chrome Vulnerability Cybersecurity communications Artificial Intelligence Business Management Managed Service Provider VoIP Remote Monitoring Employer-Employee Relationship Encryption Network Virtual Reality Hacker Apple Gadgets Tip of the week Analytics Content Filtering Spam IT Support Big Data Website Managed Service Government Money Apps Applications Infrastructure BYOD Office Tips Save Money The Internet of Things Settings Two-factor Authentication Tablet Data storage Paperless Office Virtualization Display Bandwidth Antivirus YouTube Employee-Employer Relationship Unified Threat Management VPN Education Robot Risk Management Access Control Router Wireless Printing Development Automation Firewall Customer Service Augmented Reality IT Management WiFi Avoiding Downtime Maintenance Computers Office Quick Tips Business Intelligence Storage Downtime Scam Wireless Technology Recovery Retail Hosted Solution SaaS Solid State Drive Company Culture Networking Outlook Hard Disk Drive Monitors Holiday Search HIPAA IBM Data Security Data loss Business Technology Operating System Chromebook Mobile Device Management Virtual Private Network Administration Collaboration Customer Relationship Management End of Support Hacking OneNote Server Management Bring Your Own Device Wi-Fi Computing Touchscreen Google Drive Laptop Password Mobile Security Document Management Mouse Vendor Management Telephone Systems Presentation LiFi Safety Multi-Factor Security Mirgation Voice over Internet Protocol Entertainment Uninterrupted Power Supply Patch Management Windows 8 Marketing Microsoft Excel Star Wars Training Fun Desktop Data Warehouse User Error Automobile Shortcuts Bluetooth Business Growth Application Dark Web Nanotechnology G Suite Spying Solid State Drives Google Wallet Staff Streaming Cyber Monday Social Networking Scary Stories Analysis Employee-Employer Relationships Corporate Profile Current Events Language USB Optimization Google Calendar Chatbots IP Address Cybercrime FinTech iOS Blockchain Cost Management Troubleshooting VoIP Legal Security Cameras Alt Codes Dark Data Net Neutrality Screen Reader National Security How To Drones Business Analysis Printer Wearable Technology Recycling Human Error IT service Heating/Cooling Smart Technology Motherboard Remote Computing Sports Students WannaCry Going Green Social Engineering Computing Infrastructure Dongle Knowledge Legislation Identity Update Mobile Office MSP Scalability Social Hard Drives Permissions Assessment Time Management Managing Stress Managed Services Cabling Typing FCC Smart Tech PowerPoint Updates Firefox Experience Unified Communications eWaste Device BDR Servers Deep Learning Humor Distributed Denial of Service Mixed Reality Alerts Service Level Agreement Digital Payment User Comparison Running Cable Migration Hacks Refrigeration Fraud Internet Exlporer Politics LED Network Management Public Speaking SharePoint Cables Laptops Managed IT Cryptocurrency Title II Connectivity Virtual Desktop Onboarding Techology Budget Continuity Mobility Google Maps sip Managed IT Service Modem Buisness Slack Data Breach Digital Lenovo How To Competition Licensing Private Cloud Specifications Compliance Lithium-ion battery Charging Mail Merge Value Tech Support IT solutions Smart Office Co-Managed IT Downloads IT Technicians File Sharing Wires Software as a Service Disaster Shortcut Bitcoin Network Congestion Online IoT Computer Care Digital Signage GDPR Unified Threat Management Solar Print Toner Statistics Best Practice telephony Break Fix Cookies Samsung 5G Monitoring Hard Disk Drives Spyware Superfish Information Technology Cooperation Google Docs Black Friday Regulations Halloween Messaging Address Writing Undo Hotspot Professional Services Websites Identity Theft Cortana Work Content Travel Law Enforcement Physical Security Notifications CrashOverride Upgrades Twitter Botnet Supercomputer Motion Sickness Gadget Staffing Personal Information Administrator Crowdsourcing Taxes 3D Printing Web Server Emergency Machine Learning IT Budget GPS Printers Computer Repair IT Consultant Unsupported Software Domains Processors Cameras Relocation Meetings Tracking Health Cleaning Mobile Data Alert CCTV Emoji Webcam Windows 7 Electronic Medical Records Work/Life Balance Error Black Market Point of Sale Regulation Mobile Computing