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
Thursday, February 21 2019

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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