Contact us today!

Professional Computer Associates 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!

Some Businesses Don’t Need Every Bell and Whistle
The 3 F’s of a VoIP Solution


No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Tuesday, August 21 2018

Captcha Image


Tag Cloud

Security Tip of the Week Best Practices Cloud Technology Privacy Network Security Hackers Business Computing Backup Hosted Solutions Malware Managed IT Services Google VoIP Disaster Recovery Email Microsoft Mobile Devices Software Productivity Business Business Continuity Internet Innovation Data Outsourced IT Data Backup communications Efficiency Cybercrime Hardware Smartphones Computer Ransomware Data Recovery IT Services Windows 10 IT Support Cloud Computing Android Tech Term Browser Internet of Things Office BDR Telephone Systems Computers Server Alert User Tips Network Windows Business Management Saving Money Cybersecurity Miscellaneous Smartphone Virtualization Mobile Device Management Upgrade Small Business Social Media Collaboration Quick Tips BYOD Chrome Save Money Facebook Workplace Tips Law Enforcement Microsoft Office Social Engineering Passwords Artificial Intelligence Applications Managed IT Private Cloud Bandwidth How To Money Gadgets Work/Life Balance Hacking Mobility App Router Automation Office Tips Avoiding Downtime Managed Service Provider Recovery Holiday Password Communication Productivity Firewall Office 365 Proactive IT Remote Monitoring Phishing Wi-Fi Business Intelligence Data Protection Flexibility Data Security Data Management HaaS Budget Two-factor Authentication Gmail Bring Your Own Device Operating System VPN Information Technology Managed IT Services Health Redundancy Employer-Employee Relationship Marketing Big Data User Error SaaS Spam Apps Analysis Entertainment Blockchain Black Market Encryption Identity Theft Compliance Windows 10 Training IT Management Connectivity Word Value IT Support Safety Google Drive Mobile Device Vulnerability Cleaning Document Management Risk Management Data Breach Save Time Data Storage Wireless Technology Networking Servers History Electronic Medical Records CES Workers Access Control Infrastructure Smart Tech Best Practice Shadow IT Automobile Worker Information Hiring/Firing Website Content Management Data storage Solid State Drive USB File Sharing Streaming Media PDF HIPAA Computer Care Government DDoS Meetings Internet Exlporer Wireless Comparison Wearable Technology Spam Blocking End of Support Data loss YouTube Apple Windows 7 Computing Infrastructure Mobile Computing Samsung Instant Messaging Battery Machine Learning Physical Security Legal Patch Management Business Owner The Internet of Things eWaste OneNote Keyboard Credit Cards Education Sports IT Plan Scam Paperless Office Settings Content Filtering Update Downtime Public Cloud Remote Computing Charger Unsupported Software Tech Support Current Events Students Lifestyle Digital Signature Reputation Techology Netflix Fiber-Optic Thought Leadership Going Green Users Root Cause Analysis Travel Cache Google Docs Robot Hard Drives Music Tip of the week Safe Mode Amazon Files MSP Hybrid Cloud Lithium-ion battery SharePoint Unified Threat Management Software Tips HVAC Telecommuting Relocation Video Games Benefits Computer Fan Mobile WiFi Knowledge Healthcare Strategy Customer Chromecast Books IBM Flash Cables Content Filter Laptop Virtual Reality Wireless Internet IaaS Assessment Windows Server 2008 Amazon Web Services Authentication Colocation Augmented Reality Password Manager webinar Enterprise Content Management Remote Work Insurance Scalability Smart Technology FENG Professional Services Rootkit Network Congestion Data Warehousing Electronic Health Records People Emergency Sync Managed Service Unified Communications Storage Touchpad Uninterrupted Power Supply Worker Commute Fax Server Employer Employee Relationship Wire Voice over Internet Protocol Outlook Troubleshooting Television Emails Business Technology Online Shopping Nanotechnology Tools Business Mangement Conferencing HBO Password Management Practices Distributed Denial of Service Content Specifications Accountants Mobile Office Windows 10s Telephony Proactive Theft Internet exploMicrosoft IT solutions Computer Accessories Screen Mirroring Smart Office Multi-Factor Security Human Resources Humor Hosted Solution Public Computer Regulations Virtual Assistant Evernote hacker Software as a Service Recycling Notifications Frequently Asked Questions NIST Hosted Computing iPhone Search Two Factor Authentication Advertising Audiobook Vendor Management IT Consultant Millennials Skype Remote Monitoring and Maintenance Cortana Addiction Bluetooth Supercomputer Cast Trending Staff Monitor NarrowBand Environment Telephone System Wireless Charging Devices Running Cable Botnet Criminal Experience Loyalty Excel Cryptocurrency Fraud Inventory How to Mouse Politics Leadership Workforce IoT Transportation Antivirus Audit Start Menu Line of Business Google Apps Regulation Thank You Remote Worker Congratulations Twitter Webinar Wiring Company Culture IT solutions Administration CrashOverride Managing Stress

Free Consultation

Free ConsultationSign up today for a
FREE Network Consultation
How secure is your IT infrastructure?
Let us evaluate it for free!

Sign up Now!