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
Wednesday, July 17 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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