Get Started Today!  (415) 295-4898

croom new

415 IT Blog

Tip of the Week: Formatting Shortcuts for Excel

Tip of the Week: Formatting Shortcuts for Excel

Microsoft Excel has a lot of moving parts… assuming you know how to move them, of course. For this week’s tip, we’re going over a few shortcuts to help you make the best use of some of these parts.


Perhaps the most basic Excel formatting of all, it can help to distinguish between your data to have different values aligned to the cell in different ways. Of course, there are keyboard shortcuts for each.

  • To center the value within the cell, press Alt+H+A+C.
  • To align the value within the cell to the left, press Alt+H+A+L.
  • To align the value within the cell to the right, press Alt+H+A+R.

Specific Formatting

Oftentimes, the contents of your spreadsheet will require certain formatting in order to properly communicate their significance. You can assign this formatting for different data types with the following shortcuts:

  • To return your value to general formatting, press Ctrl+Shift+~.
  • To indicate that a value refers to currency, press Ctrl+Shift+$.
  • To format a value as a percentage, press Ctrl+Shift+%.
  • To properly format a date, press Ctrl+Shift+#.
  • To format a value in scientific terms, press Ctrl+Shift+^.
  • To ensure that a number is properly formatted, press Ctrl+Shift+!.
  • To properly format time, press Ctrl+Shift+@.

Applying Borders

Borders can come in handy on a spreadsheet, as they give the differences between values more pronunciation. Use the following shortcuts to apply borders to a selected cell:

  • To cut to the chase and apply a border to all of a cell’s edges, press Ctrl+Shift+A.
  • To only add a borderline to the right edge of a cell, press Alt+R.
  • To add a border to the left edge of a cell, press Alt+L.
  • To put a border on the top edge of a cell, press Alt+T.
  • To apply a border to the bottom edge of a cell, press Alt+B.
  • To easily remove the borders from a cell, press Ctrl+Shift+_.


Okay, maybe this is the most basic Excel formatting, as these formatting needs can appear in essentially every Microsoft document you create, including your spreadsheets. These shortcuts should seem very familiar:

  • To have your data appear in a bold font, press Ctrl+B.
  • To type in italics, press Ctrl+I.
  • To underline the contents of a cell, press Ctrl+U.
  • To strikethrough the contents of a cell, press Ctrl+S.

We hope that this list comes in handy. We suggest printing it out so it can be easily accessible when needed. Are there any other programs that you’d like to know more shortcuts to? Leave a few suggestions in the comments!

Managing Millennials May Be Challenging, But Worth...
Is Your Infrastructure Hindering Your Business’ Gr...


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

Latest Blog

While all a business’ technology solutions are important, some are bound to take priority over the others, especially when certain ones become an industry-wide focus. A recent survey evaluated the top concerns of small-to-medium-sized businesses for the coming year. The resu...

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:...