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

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

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