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

      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