312-253-4321    Get SUPPORT

Alchetec 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 [email protected].

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
Sunday, August 25 2019

Captcha Image

Subscribe to Our Blog!

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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