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