312-253-4321    Get SUPPORT

Alchetec Blog

By accepting you will be accessing a service provided by a third-party external to https://www.alchetec.com/

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
Wednesday, June 03 2020

Captcha Image

Subscribe to Our Blog!

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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