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

Mobile? Grab this Article!

QR-Code dieser Seite