(707) 268-8850    Get SUPPORT

Network Management Services 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
Sunday, August 19 2018

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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