Contact us today!
866-348-2602

Total Tech Care Blog

Total Tech Care has been serving Florida since 2001, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

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!

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, 28 February 2025
If you'd like to register, please fill in the username, password and name fields.

Blog Archive

Sign Up for Our Newsletter

  • First Name *
  • Last Name *

      Free Consultation

      Sign up today for a
      FREE Network Consultation

      How secure is your IT infrastructure?
      Let us evaluate it for free!

      Sign up Now!

      Free Consultation
       

      Tag Cloud

      Security Tip of the Week Technology Best Practices Business Computing Cloud Privacy Hackers Productivity Hosted Solutions Software Efficiency Network Security Business Google Microsoft Internet Email Malware Backup Workplace Tips Innovation Data User Tips Computer Mobile Devices Hardware IT Services Disaster Recovery Android VoIP communications Smartphones Business Continuity Communication IT Support Miscellaneous Smartphone Mobile Device Browser Small Business Network Productivity Collaboration Quick Tips Cybersecurity Users Business Management Phishing Upgrade Windows Managed IT Services Data Backup Outsourced IT Ransomware Windows 10 Office Data Recovery Cloud Computing Server Save Money Passwords Windows 10 Virtualization Saving Money Holiday Social Media Gadgets Chrome Tech Term Automation Managed IT Services Managed Service Microsoft Office Computers Facebook Cybercrime Operating System Artificial Intelligence BYOD Mobile Device Management Networking IT Support Internet of Things Health Hacking Wi-Fi Remote Spam Office 365 Telephone Systems Covid-19 Information Technology Information Managed Service Provider Alert Router Bandwidth BDR Recovery Employer-Employee Relationship Social Engineering Mobility Password Data Breach Remote Monitoring Money Mobile Computing Encryption Applications App History Application Law Enforcement Human Resources Big Data Mobile Office Apps Office Tips How To Training Blockchain Government Paperless Office VPN Private Cloud Data Storage Patch Management Remote Computing Managed IT HaaS Work/Life Balance Servers Flexibility Marketing WiFi IT solutions Entertainment Website Data Security Budget Google Drive Wireless Avoiding Downtime Gmail Settings Vulnerability Two-factor Authentication Infrastructure Voice over Internet Protocol Windows 7 Word Bring Your Own Device Data Management Mouse Cleaning User Error Vendor Management Meetings Data Protection End of Support Vendor Education Physical Security Risk Management Managed Services Safety Display Hacker Sports USB HIPAA Redundancy Keyboard The Internet of Things Lithium-ion battery Employee/Employer Relationship Telephone System Staff RMM Software as a Service Machine Learning Remote Work Firewall Connectivity Conferencing Save Time Virtual Reality Apple Scam Social Computing Infrastructure Fraud Botnet Net Neutrality Workplace Strategy Unified Threat Management Going Green IT Plan Help Desk Remote Worker Computer Accessories Printing Cryptocurrency Unsupported Software Wearable Technology Battery Hard Drives Shadow IT Charger Retail Instant Messaging Legal Managed Services Provider Compliance Robot Excel Printer Comparison Internet Exlporer Database OneNote Computer Care Bluetooth Current Events Biometrics CES Telephony Virtual Desktop Remote Workers PDF Samsung Business Technology Content Management Processor DDoS Access Control Proactive IT Value IT Consultant SharePoint Virtual Assistant Hard Drive Best Practice Spam Blocking Electronic Medical Records Authentication Humor YouTube Black Market Computing Hiring/Firing Customer Service Environment Update Fax Server Document Management Solid State Drive Wireless Technology How to Downtime Google Docs Identity Theft Digital Signage SaaS Business Intelligence Data storage Audit Worker Automobile IT Management Network Congestion eWaste Augmented Reality Virus Procurement PowerPoint Social Network Windows Media Player Computer Fan Search Engine Rootkit User Twitter Tablets NIST Entrepreneur Business Mangement Investment Streaming Media Workers Benefits Employees Smart Tech Reputation Employee/Employer Relationships Trending Amazon Tech Support ISP FENG Shortcut Managing Stress Content Windows 365 Addiction IBM Cost Management Techology Video Conferencing Recycling Laptop ROI Flash Shortcuts Wiring Smart Technology Social Networking Sales Practices Cameras Customers Bitcoin Personal Amazon Web Services Cryptomining Audiobook Point of Sale Cache Supercomputer Safe Mode Supply Chain Management Criminal Touchpad Software Tips Sync Emails Running Cable GDPR Monitoring Hosted Computing Batteries Memory Advertising Digitize Online Shopping Politics Windows 8.1 Wireless Internet File Sharing Windows Server 2008 R2 Notifications Netflix Camera Two Factor Authentication Customer relationships Inventory Printer Server Specifications Email Best Practices Wire IT Assessment Evernote Manufacturing Root Cause Analysis Knowledge Music Travel HBO Managed IT Service Millennials Skype Security Cameras Printers Computer Tips Science Relocation Virtual CIO Smart Office OneDrive Wireless Charging Biometric Security Data loss Leadership Troubleshooting Video Games Peripheral Outlook Using Data Workforce Start Menu Distributed Denial of Service Virtual Private Network Customer Relationship Management Worker Commute Digital Security Cameras Experience Analyitcs Copiers Cables 5G Screen Mirroring Loyalty Books Programming Scalability Quick Tip Frequently Asked Questions Telecommuting Mobile Smartwatch Windows 10s Project Management Business Owner Ergonomics Nanotechnology Development Cortana NarrowBand OLED Cast webinar Antivirus Emergency Consultant Search PCI DSS Digital Signature Virtual Machine Tip of the week iPhone Fiber Optics Professional Services Employee Public Cloud Warranty Employer Employee Relationship 2FA Windows 8 Analytics HVAC Messaging Google Apps Cabling Assessment IT service Best Available Policy Analysis Hypervisor Windows Server 2008 Files Trend Micro Tools Administrator WIndows 7 Dark mode Devices Tablet Enterprise Content Management SMS Chromecast Default App Television Domains MSP Procedure Accountants Saving Time Colocation Shopping Credit Cards Uninterrupted Power Supply Google Search IaaS Microchip Maintenance dark theme Thought Leadership Password Management Bloatware AI Password Manager IT Infrastructure Public Computer Bing Transportation FinTech Monitor Multi-Factor Security Regulations

      Top Blog

      The reasoning for this is simple: you want to make sure that operations are proceeding as intended, even if you’re not there. If you completely check out from the workplace every time you leave, you could return from your vacation to a complete and total disaster that may have been prevented with y...
      QR-Code