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

 

Comments

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

Captcha Image

Subscribe to Our Blog!

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

What Our Clients Say

  • BNMC has provided us with nothing less than outstanding service and results for all of our IT needs for the past few years. Every member of their staff is professional, knowledgeable, friendly and eager to solve any problem...
  • 1
  • 2
  • 3