Get Started Today!  (415) 295-4898

croom new

415 IT Blog

Tip of the Week: Handy Tricks to Formatting Excel Spreadsheets

Tip of the Week: Handy Tricks to Formatting Excel Spreadsheets

Microsoft Excel is, for many, the de facto spreadsheet-creation software. However, fewer know about its useful formatting capabilities and shortcuts. To help you make your own Excel sheets more comprehensible, we’re sharing some tips to help you format your documents.

Fast Table Format

When you have a data set that outlines different related data points, using a table is one of the best ways to review it, as the table allows you to reorganize and filter the data it includes. If your data is already in a spreadsheet, you can quickly create a table by selecting a cell and pressing Ctrl + T, and then pressing Enter.

Excel Formatting Shortcuts

Of course, when you’re hard at work on a spreadsheet, you don’t want to spend too much time playing with a whole lot of nitty-gritty formatting but this kind of formatting could potentially make your spreadsheet that much more easy to understand.

In addition to the familiar Ctrl + B for bold, Ctrl + I for italics, and Ctrl + U for underline, Excel offers plenty of other shortcuts to help you format your sheets. For instance, pressing Ctrl + 5 when text is selected will mark that text with a strike through, while pressing Ctrl + 1 with anything highlighted will bring up a format dialog box for that selection. Pressing F4 will repeat the last action, which is handy if you want to apply specific formatting to certain cells.

Icon Sets

Adding icons to your cells can help provide some context at a glance, and it is simple to do. With the cells you intend to accentuate highlighted, click on Conditional Formatting (which can be found under the Home tab. You will see an option for Icon Sets, where you can select the icon set that best suits your needs.

In fact, these icons are preconfigured to differentiate between certain data ranges. For instance, if you were to pick the option with three arrows, the downward arrow represents when your data is in the lower 33 percent, the sideways arrow the middle 33 percent, and the upward arrow the top 33 percent. These numbers shift with the number of icons you have available, divvying up evenly.

What Excel formatting tricks do you know? Share them with us in the comments!

4 Tools that Every Small Business Should Use
Remote Monitoring and Managed IT, and the Impact i...


No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Monday, September 21 2020

Captcha Image

By accepting you will be accessing a service provided by a third-party external to

Mobile? Grab this Article

QR Code

Tag Cloud

Security Tip of the Week Productivity Technology Business Computing Best Practices Data Backup Data IT Support Network Security Privacy Hosted Solutions Cloud IT Services Efficiency Data Recovery Software Internet Email Business Managed IT Services Malware Outsourced IT Innovation Small Business Cybersecurity Google Business Management Hackers Tech Term Collaboration User Tips Cloud Computing Hardware Upgrade Phishing Computer Business Continuity Windows 10 Microsoft Mobile Devices Managed Service Smartphone VoIp Workplace Tips Communication Mobile Device Android Quick Tips Managed Service Provider Ransomware Paperless Office Backup Disaster Recovery Encryption Covid-19 Communications Smartphones Data Management Remote Work Browser Saving Money Office 365 Business Technology Server Managed IT Network BDR Remote Monitoring Wi-Fi Document Management Users Windows 7 Artificial Intelligence Social Media Healthcare Vulnerability Internet of Things Compliance Passwords Holiday Chrome Miscellaneous Help Desk Laptops Microsoft Office Government Data Security Save Money Facebook Applications Blockchain Managed IT services Processor Vendor Management Analytics Avoiding Downtime Bandwidth Health Antivirus Office Automation Project Management Two-factor Authentication Scam Redundancy Virtualization Employer-Employee Relationship Tip of the week Information Proactive IoT Regulations Meetings IT Management Hard Drive Gadgets Files Access Control Virtual Private Network Mobile Office Customer Relationship Management Windows Router Storage BYOD Employee-Employer Relationship Machine Learning Training OneDrive Data Loss Website Infrastructure Apps Software as a Service Maintenance VPN Company Culture Mobility RMM Search Server Management Social Network Smart Technology Computing Monitoring Management File Sharing Remote Worker Remote Monitoring and Management File Management Assessment Financial Operating System Mobile Security Network Management Flexibility Payment Cards Bring Your Own Device Word Employees Co-Managed IT HIPAA Utility Computing Consultation Electronic Health Records Unified Communications Instant Messaging Information Technology Patch Management Consulting Data Breach Downtime The Internet of Things Professional Services Time Management Gmail Managed Services Cooperation Managed Services Provider Risk Management Remote Workers Money Recycling Alert Net Neutrality Unified Threat Management Data Storage Tablet Internet Exlporer Networking Dark Web Augmented Reality Password Authentication CIO applications E-Commerce Unified Threat Management Theft Gamification Google Calendar Fraud Managing Stress CRM Alerts Nanotechnology Wires Windows Server Shortcut Proactive IT Electronic Medical Records Digitize Chatbots Employer/Employee Relationships Apple Travel Mobile Computing Database OneNote Permission Computers Virtual Reality Mirgation Hard Disk Drives Sensors Enterprise Content Management Notes Websites Lenovo Authorization Windows Server 2008 Firewall Wearable Technology Star Wars Features Spam Samsung Politics Content Filtering Comparison Licensing App User Management IT Consulting Shadow IT Identity Theft Enterprise Resource Planning Proactive Maintenance Solid State Drive Technology Tips Geography Voice over Internet Protocol Projects How To Test Holidays Data Warehousing Cache Solid State Drives SharePoint Private Cloud Social Networking PowerPoint Display WPA3 SaaS Superfish Distributed Denial of Service Value of Managed Services Mail Merge User Error Procurement Outsource IT Legislation Remote Specifications Screen Reader Teamwork Outsourcing Identity Cybercrime Cyber security Peripheral Digital Payment Hotspot Modem High-Speed Internet Return on Investment Touchscreen Hacking IT Operations Remote Computing Options Telephone Bookmarks Downloads ROI G Suite Fleet Tracking Zero-Day Threat Optimization Managed IT Service Tech Support Address Cyberattacks WiFi Social Laptop Heating/Cooling Customer Service Banking Black Friday Smart Tech Shared resources Going Green Mobile Device Management Video Conferencing Mobile Database Management PCI DSS Mouse Language Development Settings Personal Information Trending Techology Wireless Business Telephone 5G Mobile VoIP Favorites Motherboard Chromebook Virtual Assistant Bitcoin Asset Tracking Statistics Backup and Disaster Recovery Virtual Machines Break Fix IT Technicians Cost Management Manufacturing Vendor Read Only Security Cameras Remote Working MSP Servers Finance Cyber Monday Staff Connectivity Batteries Point of Sale Technology Laws Tech Terms Biometric Permissions GDPR Multi-Factor Security Computing Infrastructure Cookies Cables Transportation Active Directory Outlook Disaster Resistance IT Assessment Microsoft Excel Migration eWaste Wireless Internet Big Data Emergency Conferencing Budget Vulnerabilities Wasting Time Current Events Bluetooth Human Error Credit Cards Smart Devices Recovery Printer Printing Marketing Education CEO Students Daniel Stevens Regulation Twitter Printers

Latest Blog

Did you know that, as of July 2020, 69 percent of global desktop Internet users utilized Google Chrome as their browser of choice? With such a large market share, the security associated with Google Chrome is important to keep in mind. To help increase some of this awareness...

Latest News

We are proud to announce that 415 IT and our CEO, Daniel Stevens, were recently featured by CIO Applications. We discussed how and why we serve our clients, as well as some sneak peeks for our future. Read our interview by visiting:  https:...