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: Useful Excel Shortcuts

Tip of the Week: Useful Excel Shortcuts

When most people think “spreadsheet,” they’re thinking about Microsoft Excel. Yet, for how well-known it is, many people are unaware of many of its capabilities. This is particularly true of the shortcuts available to properly format these spreadsheets. For this week’s tip, we’re sharing a few of these formatting tips.

Quick and Easy Tables

Let’s face it—a spreadsheet full of points and figures isn’t the most comprehensive way to view your data. It is far better to instead format that data into a table, as you can then reorganize it and filter it as needed. Once your data is in a spreadsheet, creating a table is as simple as selecting one of your cells, pressing Ctrl + T, and then hitting Enter.

Handy Formatting Shortcuts

Formatting a spreadsheet is a matter of balance. While it isn’t something you want to spend a ton of time and effort doing, it can add a significant amount of comprehension for the person reviewing it. Shortcuts can help make this formatting less intrusive, and more efficient for you, the person creating the spreadsheet in the first place.

Here are a few select shortcuts that you will likely find useful:

  1. Ctrl + B – Bold
  2. Ctrl + I – Italics
  3. Ctrl + U – Underline
  4. Ctrl + 5 – Strikethrough selected text
  5. Ctrl + 1 – Format box for selection
  6. F4 – repeats the last action

Icon Sets

On the topic of visibility, some trends can be challenging to spot without this kind of added context as well. Excel has icons that can automatically put in a bit of visual context. With the cells you want to add the icons to highlighted, click on Conditional Formatting under the Home tab of the menu. There, the Icon Sets option should appear, where you can select the set of your choosing.

These icons are particularly handy because they are automatically configured to adjust to your data. Let’s assume that you pick the icon set with three arrows. Based on the range your data covers, the lowest third is automatically assigned the downward arrow, the middlemost third has the sideways arrow, and the highest third gets the ascending arrow. With five icons, your range is split into fifths, as your range is automatically divided amongst the icons.

What are some of your favorite formatting tricks for Excel? Share them in the comments!

 

Comments

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

      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