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