Home

About Us

IT Services

Understanding IT

News & Events

Blog

Support

Contact Us

Blog
  • 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
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, March 22, 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

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