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

      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