Bredy Network Management Corporation Blogs

2 minutes reading time (440 words)

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
Monday, August 20 2018
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Subscribe to Our Blog!

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

Sign up for our Newsletter!

  • Company Name *
  • First Name *
  • Last Name *

      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