Male Rep1

 

 "Affordable, Effective, and Fast"

Have IT Questions?
Call us now (888) 894-6411

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!

5 Useful Cloud Apps for Small Businesses
The 3 F’s of a VoIP Solution

Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Tuesday, August 21 2018
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Mobile? Grab this Article!

QR-Code

Our 10 Benefits

Our 10 Benefits Whitepaper

This whitepaper will evaluate the differences between traditional technical support practices and modern managed IT practices and the pros and cons of both in regards to small and medium-sized businesses.

Download Now!   Need A Consultation?

Tag Cloud

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