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, November 18 2018

Captcha Image

Subscribe to Our Blog!

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

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