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

Captcha Image

Tag Cloud

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

Mobile? Grab this Article!

QR-Code dieser Seite