(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


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