094 90 48200     Get SUPPORT

Aniar IT Services Blog

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
Monday, August 20 2018

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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