About Us

IT Services

Understanding IT

News & Events



Contact Us

  • Register

Alternative IT Solutions 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


No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Friday, October 19, 2018

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

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