About Us

IT Services

Understanding IT

News & Events



Contact Us

  • Register
3 minutes reading time (508 words)

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


No comments made yet. Be the first to submit a comment
Already Registered? Login Here
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 dieser Seite

Tag Cloud

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

Latest News & Events

Alternative IT Solutions is proud to announce the launch of our new website at https://www.alternative-IT.co.uk. The goal of the new website is to make it easier for our existing clients to submit and manage support requests, and provide more information about our ser...

Contact Us

Learn more about what Alternative IT Solutions can do for your business.

Call Us Today
Call us today
(0)20 8498 4300

Avocet House, Trinity Park, Trinity Way
London, England E4 8TD