(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, March 24 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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