(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
Tuesday, December 18 2018

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