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
Monday, February 18 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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