094 90 48200     Get SUPPORT

Aniar IT Services 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
Tuesday, October 23 2018

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Tip of the Week Security Technology Best Practices Privacy Tech Term Google Email Cloud Business Computing Data Backup Microsoft Network Security Hackers Innovation User Tips Data Recovery Hardware Internet VoIP Malware Data Cloud Computing Mobile Devices Workplace Tips Communication Browser Android IT Services Backup Internet of Things Windows 10 Managed IT Services Smartphones Artificial Intelligence How To Small Business Communications Saving Money Cybercrime Applications Computers Chrome Computer Cybersecurity Windows Smartphone Network Software Collaboration Miscellaneous Word Ransomware Business Connectivity Facebook Router Spam Mobile Device Management Money Data Security Two-factor Authentication BDR Passwords Server Information Outsourced IT Hosted Solutions Efficiency Business Continuity Gadgets Vulnerability Data Protection Business Management IT Support Office 365 Telephone System Avoiding Downtime Phishing Upgrade Productivity Social Media Comparison IT Plan Sports Remote Monitoring CES OneNote Settings Law Enforcement Fraud Encryption Virtualization Infrastructure Unsupported Software Data Storage Scam Content Management Managed IT Keyboard Update Business Intelligence VPN Password Spam Blocking Virtual Assistant Apps Blockchain Windows 7 Bring Your Own Device Managed Service Managed IT services Microsoft Office Operating System IT Management Save Money Redundancy Paperless Office Telephone Systems App BYOD Social Engineering Website Identity Theft Mobile Device Windows 10s Google Drive Sync Multi-Factor Security Electronic Medical Records Wire Downtime Entertainment Warranty Google Apps NIST Addiction Unified Threat Management Millennials Online Shopping Screen Mirroring Excel Gmail Audit Physical Security File Sharing Credit Cards PDF Employer-Employee Relationship HVAC Workers Access Control Private Cloud Data Management Root Cause Analysis Machine Learning Printer Cryptocurrency Flash Google Docs Mobile Computing Value Workforce Evernote Cleaning Cast Tip of the week Recycling Devices Training Specifications Authentication Public Cloud Telephony Trending Wi-Fi Human Resources YouTube Mouse Safe Mode HaaS Cache Smart Office Practices Windows Server 2008 eWaste Thought Leadership Computer Fan Remote Worker Amazon Augmented Reality Data loss Networking Bandwidth Software Tips Staff HBO Wireless Internet Document Management Camera Botnet Telecommuting Charger Hosted Computing Computer Care Legal Automation FENG Wiring Disaster Recovery The Internet of Things Amazon Web Services Accountants Cortana Alert Enterprise Content Management Outlook Government Password Manager Nanotechnology Skype Voice over Internet Protocol HIPAA USB Travel Remote Work Wireless Charging Inventory Password Management Patch Management Criminal Firewall Tools Work/Life Balance Big Data Holiday Frequently Asked Questions Recovery Business Mangement Smart Tech Solid State Drive MSP Start Menu Digital Signature Meetings Servers Customer Service WiFi Mobile Office Fun Domains Compliance Wireless Windows 10 Public Speaking Regulation Presentation Hard Drives Lithium-ion battery Search Quick Tips Tech Support Wireless Technology 5G Company Culture Safety CrashOverride IBM Marketing Hacker Emergency Productivity Budget Managing Stress Competition Managed Service Provider Printers Customer Relationship Management IP Address Twitter Users Hiring/Firing