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


Already Registered? Login Here
No comments made yet. Be the first to submit a comment

Mobile? Grab this Article!

Qr Code

Tag Cloud

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