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.

Align

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+_.

Appearance

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

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Tuesday, August 20 2019

Captcha Image

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