window._mfq = window._mfq || []; (function() { var mf = document.createElement("script"); mf.type = "text/javascript"; mf.async = true; mf.src = "//cdn.mouseflow.com/projects/0148bb62-7ff8-46ae-a466-bf3fd13c7d09.js"; document.getElementsByTagName("head")[0].appendChild(mf); })();
407-478-6600    Get SUPPORT

TaylorWorks Blog

Tip of the Week: Excel Features for the Power User

Tip of the Week: Excel Features for the Power User

As useful as a spreadsheet can be to convey information, they can be a little drab and disengaging if the full capabilities of Microsoft Excel aren’t understood and leveraged. For today’s tip, we’ll go over a few little-known and underutilized features that can help you create spreadsheets with both more style, and more utility.

Visible Zeros
There is a fair chance that, at some point, you will need to input data into Excel that begins with zeroes, whether you’re documenting serial numbers or what have you. The trouble is, Excel has a habit of hiding these zeros, so 0056907 would display as 56907. This unfortunately renders the data inaccurate. However, an easy fix to this is to just add a quotation mark in front of the number. This prevents the zeros from being omitted, so instead of resulting in 56907, you would keep your original “0056907.

Adding a Drop-Down List
Adding a drop-down list to a spreadsheet is a simple, yet effective way to limit the input a particular cell will accept. The first thing you have to do is select the cell that needs to have drop-down capabilities, and then click Validate in the Data tab in the header menu. On the Settings page of the window that pops up, there will be a menu labelled Allow. From that menu, select List and highlight the cells that make up the options you want in your drop-down, and finally, click OK.

Accessing Tools on the Developer Tab
Depending on your needs, you may require some more advanced capabilities in your spreadsheet, like creating option buttons, creating macros, and other features. These can all be found in the Developer tab, which is hidden by default. In order to access it, you will first have to access the Excel menu at the top of your screen and select Preferences. Once you’re provided with the Preferences menu, select Ribbon & Toolbar. You will then see a list of the various options that you can add or remove from your Tabs. Selecting Developer will give you access to the tools that tab contains.

Shading Every Other Row
If spreadsheets have any faults, the eye can easily wander when one is looking at them. Adding shading to the formatting, more specifically, to break up individual rows can be very helpful to someone trying to read the information the spreadsheet has to share. To do this, you will need to highlight the area where you want to display the effect or use the Select All shortcut (Ctrl + A) to apply the effect to the entire sheet. In the Home tab, click into Conditional Formatting and select New Rule from the drop-down menu. You will then have a Style drop-down menu to select from, from which you should pick Classic, after which you should 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.

Do you know any other tricks to improve the use of Microsoft Excel? Share them in the comments!

Some Businesses Don’t Need Every Bell and Whistle
The 3 F’s of a VoIP Solution
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Tuesday, August 21 2018
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Newsletter Sign Up

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

      Tag Cloud

      Tip of the Week Security Technology Cloud Best Practices Managed IT Services Network Security Privacy Business Computing Data Backup Email Hackers VoIP Malware Hosted Solutions Outsourced IT Data Recovery Backup Mobile Devices Microsoft Google Tech Term Cloud Computing Data Software Saving Money Internet of Things Business Continuity Innovation IT Support Hardware Internet Efficiency BDR Small Business Cybersecurity Android User Tips Smartphones Disaster Recovery Communications IT Services Cybercrime Ransomware Network Business Router How To Artificial Intelligence Applications Communication Law Enforcement Gadgets Managed IT Managed IT Services Business Management Data Protection Smartphone Money Phishing Mobile Device Management BYOD Chrome Two-factor Authentication Collaboration Business Intelligence Windows Productivity Avoiding Downtime IT Support Browser Data Security Computers Virtualization Blockchain Windows 10 Social Media Vulnerability Spam Telephone Systems Alert Analysis Identity Theft Mobility Word Document Management Computer Social Engineering Passwords Apps Compliance Connectivity Productivity App Remote Monitoring Save Money Facebook Proactive IT Redundancy Bandwidth IT Management Office 365 Miscellaneous Information Private Cloud IT Plan Upgrade Server Networking Access Control Workers Windows 7 Paperless Office Smart Tech Comparison Unsupported Software Business Owner Training Holiday OneNote Education Bring Your Own Device Data Storage Wi-Fi Infrastructure VPN Mobile Device Servers Credit Cards Data Breach Update Work/Life Balance Spam Blocking Employer-Employee Relationship Automation File Sharing Microsoft Office CES Budget Firewall Data loss Value Operating System Flexibility Big Data Solid State Drive Encryption Machine Learning Password Website Information Technology Content Management Password Management Leadership Hacking HBO Gmail Addiction Windows 10s Instant Messaging Professional Services IoT Voice over Internet Protocol Computing Infrastructure Theft Thought Leadership Unified Threat Management Netflix HIPAA Sync Amazon Web Services Strategy YouTube Worker Commute Legal Entertainment Remote Work Battery Cast Software as a Service NIST Wireless Outlook Managed Service Public Cloud Recycling Cache SaaS USB Tools Multi-Factor Security Business Technology Google Apps Streaming Media Cleaning Settings Remote Computing Windows 10 Telephony Online Shopping Cortana Current Events Authentication Regulations Human Resources Students Government Insurance Cryptocurrency webinar Data Management Frequently Asked Questions Specifications Managed Service Provider Proactive eWaste Wireless Internet Audit Recovery Root Cause Analysis Software Tips Trending Virtual Assistant End of Support Content Filter Computer Care Keyboard Skype Evernote Knowledge Fiber-Optic Nanotechnology Emails Augmented Reality Staff Healthcare Health Office Tips Practices Safe Mode Conferencing Wireless Technology Excel Millennials Remote Monitoring and Maintenance PDF Criminal Wire Meetings Botnet Save Time Physical Security Lifestyle Telephone System Password Manager Storage Samsung Start Menu Wireless Charging Technology Tips Accountants HVAC Network Congestion HaaS Cables Charger The Internet of Things Risk Management Flash Fraud Digital Signature Electronic Health Records Downtime Marketing Hacker Patch Management Data Warehousing Hosted Computing Tip of the week Workforce Line of Business Google Drive Sports Computer Fan Travel IT Consultant Mobile Computing Business Mangement Workplace Tips Mobile Enterprise Content Management Electronic Medical Records Google Docs Unified Communications Devices Amazon Virtual Reality Scam Inventory Windows Server 2008 Telecommuting Hard Drives MSP Smart Office FENG Users Black Market Content Filtering Screen Mirroring Search Loyalty Customer Service Wearable Technology Relocation Video Games Mobile Office Transportation Techology Rootkit Domains Remote Worker Books Employer Employee Relationship Automobile How to Humor Benefits Internet Exlporer Company Culture User Error Best Practice Public Speaking Wiring Computer Accessories Presentation Hybrid Cloud Troubleshooting Lithium-ion battery Smart Technology Scalability Managing Stress Two Factor Authentication Vendor Management Hiring/Firing CrashOverride Emergency Bluetooth 5G Assessment Shadow IT Tech Support Hosted Solution Safety Fun Internet exploMicrosoft IBM Experience Quick Tips Webinar WiFi Files Content Television Competition Regulation Advertising Twitter Customer Relationship Management Music Office Colocation IT solutions Politics IP Address History Worker Audiobook Public Computer

      Mobile? Grab this Article!

      QR-Code dieser Seite