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!



No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Thursday, August 16 2018

Captcha Image

Tag Cloud

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

Mobile? Grab this Article!

QR-Code dieser Seite

Recent Comments

JeffereyANoah 5 Useful Cloud Apps for Small Businesses
15 August 2018
Sharing these type stuff is very useful and hope you will provide us more like this one. I come here...
Jared Albert VoIP Delivers Benefits That a Traditional Phone System Can’t
13 August 2018
A traditional telephone system is installed for the happiness of the people. Majority of the concern...
Meredith Maddox Tip of the Week: Tip of the Week: Mirror or Cast Your Android Device’s Screen
08 August 2018
Android mobile phones are top of the list now a days every one wants to buy android phone. It’s a bi...
MarianneJCruz Tip of the Week: Got a Solid State Drive? Here’s How to Take Care of It
31 July 2018
What a review https://www.uk.com/how-do-you-do.html
Digital Hold The Case for Hosting Your Phone Solution In-House
24 February 2018
Informative Blog. Thanks a lot for the useful info.