Contact Us Today! 1-844-237-4300

Central Technology Solutions 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, June 06 2020

Captcha Image

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

Join our mailing list!

  • Company Name *
  • First Name *
  • Last Name *

      Mobile? Grab this Article!

      QR-Code dieser Seite

      Tag Cloud

      Security Tip of the Week Technology Best Practices Business Computing Productivity Cloud Data Privacy Hosted Solutions Network Security IT Services Data Backup Email Malware Internet Hackers Software Efficiency IT Support Outsourced IT Business Innovation Microsoft Mobile Devices Productivity Computer Data Recovery Managed IT Services Hardware Google Upgrade Business Continuity IT Support Small Business Cloud Computing Ransomware Cybersecurity Backup User Tips Communication Tech Term Collaboration Phishing Managed IT Services Managed Service Provider Business Management Workplace Tips Disaster Recovery Windows 10 Smartphones Internet of Things VoIP Android Smartphone Remote Monitoring Data Management Mobile Device Social Media Paperless Office Managed IT communications Facebook Encryption Managed Service Quick Tips Server Network Save Money Browser Office 365 Windows 10 Artificial Intelligence Windows Virtualization BDR Saving Money Miscellaneous BYOD Help Desk Wi-Fi Risk Management Holiday Passwords Automation App Healthcare Vendor Management Business Technology Compliance Password Health Government Mobile Device Management Apps Document Management Windows 7 Laptops Recovery Employer-Employee Relationship Big Data Training Avoiding Downtime Bring Your Own Device Remote Work Users Chrome Going Green Bandwidth Robot Analytics Unified Threat Management Microsoft Office Gmail Firewall Applications Tip of the week Scam Antivirus Project Management Money Two-factor Authentication Data storage Computing Infrastructure Mobility File Sharing Data loss Vulnerability Data Security Wireless Blockchain Hosted Solution Website Telephone Systems Information SaaS Office Processor Content Filtering Computers IT Management Apple Storage Redundancy Social Proactive Software as a Service Gadgets Flexibility VPN Router Maintenance Customer Service Customer Relationship Management Unified Communications Machine Learning Virtual Private Network Budget Virtual Reality Information Technology Operating System Printing Tablet Downtime Meetings IoT Files Access Control Regulations Remote Computing Settings OneDrive IT Service Politics Company Culture Work/Life Balance RMM Utility Computing Websites Consulting Identity Theft Dark Web Sports Hacker Augmented Reality How To Samsung Solid State Drive Covid-19 Licensing Wireless Technology Legal Remote Worker Current Events The Internet of Things Managed Services Provider Chromebook Employee-Employer Relationship Patch Management Smart Technology Time Management Networking Remote Monitoring and Management Mobile Office Management Net Neutrality Social Network Spam YouTube Upgrades Bitcoin Remote Workers WiFi Network Management Twitter File Management Assessment Internet Exlporer Mouse Server Management HIPAA Hard Drive Outlook How To Payment Cards Administration Display Cooperation Google Drive Uninterrupted Power Supply Education End of Support Consultation Mobile Security LiFi Private Cloud Electronic Health Records Co-Managed IT Tech Support Monitoring IT solutions Monitors Business Growth Employees Alert Word Search Professional Services Managed Services Electronic Medical Records Recycling Mobile Computing Digital Payment Biometric Mobile Data Backups Spyware Course Motherboard Transportation Mobile VoIP Development Drones Cybercrime Zero-Day Threat Downloads Proactive IT Employer/Employee Relationships IT Assessment Telephony OneNote Shortcut Cyber Monday technology services provider Virtual Assistant Vendor Marketing Deep Learning Managing Stress Sync Instant Messaging User Error Language Law Enforcement Tech Terms Migration Batteries Dark Data Personal Information eWaste Public Cloud Read Only Firefox Smart Tech Hard Disk Drives Virtual Machines Buisness Safety IT Consulting Operations Projects Gamification Botnet Data Warehousing Cyber security Alt Codes Cables Travel Backup and Disaster Recovery Heating/Cooling Proactive Maintenance Digitize Notifications Cryptocurrency WannaCry Technology Assurance Group ’s 18 Wasting Time Smart Devices Enterprise Content Management Mobile Device Managment Finance Software Tips Computing Infrastructure Gadget Theft Hacking Technology Tips Chatbots ROI Automobile Computer Care Solid State Drives Credit Cards Black Market Servers Multi-Factor Security Data Breach Wearable Technology Return on Investment Cost Management Hacks E-Commerce Microsoft Excel Modem Teamwork Writing Emoji Typing Wires Human Error Database Management Shadow IT Connectivity GPS Distributed Denial of Service Annual Convention Database Sensors Network Congestion Best Practice Vulnerabilities Authentication Printer Alerts WPA3 Financial Disaster Trending Comparison Identity Outsource IT Notes Computer Repair Enterprise Resource Planning Bookmarks Options Holidays Permission Google Calendar Technology Laws Active Directory Physical Security Features Supercomputer Mail Merge Cookies Shared resources Windows Server 2008 Retail Cortana Crowdsourcing GDPR Outsourcing 3D Printing Windows 8 Save Time Tracking VoIP Sponsor Managed IT Service San Diego Voice over Internet Protocol Geography G Suite Authorization History Touchscreen Techology Processors Identities Fleet Tracking Taxes Procurement Specifications Laptop PowerPoint Value of Managed Services Mobile Favorites Google Maps Lenovo 5G IT Test Statistics Legislation IT Technicians Windows Server Virtual Desktop Office Tips Cache IT Budget Address Permissions Nanotechnology Video Conferencing Unsupported Software Virus Star Wars Digital Obstacle Break Fix Social Networking Telephone Update High-Speed Internet Google Wallet Cabling SharePoint Disaster Resistance Staff Hard Drives Asset Tracking Google Docs Black Friday Roanoke — Central Technology Solutions Remote Working Conferencing Unified Threat Management Superfish Hotspot Wireless Internet Business Telephone MSP Point of Sale Bluetooth Mirgation Security Cameras User Management Cyberattacks Humor Fraud Screen Reader Manufacturing Optimization Social Engineering USB Hard Disk Drive Web Server Students Peripheral Cameras Printers Emergency CrashOverride Motion Sickness CCTV Administrator Relocation Regulation Webcam IT Consultant Error