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

      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