Get Started Today!  (415) 295-4898

croom new

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

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

Security Tip of the Week Technology Productivity Best Practices Business Computing Data Backup Hosted Solutions Network Security IT Support Cloud Privacy Software Data Recovery Data IT Services Email Malware Tech Term Outsourced IT Business Computer Internet User Tips Managed IT Services Windows 10 Innovation Hackers Cloud Computing Business Management Efficiency Microsoft Small Business Collaboration Ransomware Upgrade Mobile Devices Android Paperless Office Hardware Phishing Google Encryption Server Remote Monitoring Business Continuity Managed Service Provider VoIp Communication Communications Artificial Intelligence Office 365 Vulnerability Managed IT Smartphones Workplace Tips Backup Cybersecurity Browser Applications Internet of Things Managed IT services Passwords Business Technology Holiday Data Management Laptops Managed Service Save Money Quick Tips Healthcare Saving Money Automation Microsoft Office Compliance Blockchain Mobile Device BDR Smartphone Processor Employer-Employee Relationship Tip of the week Project Management Information Disaster Recovery Scam Wi-Fi Help Desk Government Document Management Bandwidth Antivirus BYOD Social Media Website Access Control Windows Data Security Infrastructure RMM Vendor Management Chrome Two-factor Authentication IT Management Router Avoiding Downtime VPN Analytics Customer Relationship Management Windows 7 Training Consultation Mobile Security Employees Unified Communications Facebook Downtime Files Virtual Private Network The Internet of Things Company Culture Gmail Network Risk Management Cooperation Word Remote Workers Unified Threat Management Software as a Service Net Neutrality Regulations Patch Management IoT Management Tablet File Sharing Internet Exlporer Server Management Data Loss Proactive Smart Technology Alert Storage Monitoring Redundancy Maintenance Assessment HIPAA Bring Your Own Device Remote Monitoring and Management Financial Users Machine Learning Networking Operating System Network Management Professional Services Tech Support Search How To Test Technology Tips OneDrive SaaS G Suite Unified Threat Management Office Private Cloud Data Warehousing Flexibility WPA3 Legislation Shared resources Mobile Shortcut Proactive IT Electronic Health Records Procurement Distributed Denial of Service Database Management Smart Tech Settings Personal Information Recycling Consulting Specifications 5G Touchscreen Hacking Development Instant Messaging Virtual Assistant Bitcoin IT Technicians Cost Management Lenovo Employee-Employer Relationship Digital Payment Hotspot Manufacturing Time Management Motherboard Chromebook Bookmarks ROI Operations Samsung Fleet Tracking Zero-Day Threat Virtualization Heating/Cooling IT Consulting Cyberattacks Social Managed IT Service GDPR Connectivity Customer Service Transportation Active Directory Migration eWaste Managed Services Provider Mobile Device Management Black Friday Wireless Internet Trending Cookies Cables SharePoint Wasting Time Current Events Superfish Wireless Mouse Language Password Statistics Vulnerabilities Mail Merge User Error Favorites Apps Money Asset Tracking Backup and Disaster Recovery CIO applications Servers Managing Stress Data Breach Read Only Security Cameras Break Fix MSP Finance Permissions Windows Server Chatbots Point of Sale Tech Terms Cyber Monday Staff Employer/Employee Relationships Mobility Nanotechnology Wires Downloads Database Miscellaneous Recovery Mirgation Hard Drive Computing Infrastructure Hard Disk Drives Bluetooth Mobile Computing Address WiFi Conferencing Microsoft Excel Wearable Technology Star Wars Human Error Spam Enterprise Content Management Printing Dark Web Augmented Reality Notes Authentication Google Calendar Fraud User Management Identity Theft Enterprise Resource Planning Techology E-Commerce Theft Proactive Maintenance App Voice over Internet Protocol Gadgets Projects Cache Electronic Medical Records Computing Alerts Solid State Drives Geography Meetings Utility Computing OneNote Permission Travel Websites Social Networking Technology Laws Remote Worker Virtual Reality PowerPoint Display Multi-Factor Security Authorization Teamwork Information Technology Identity Outlook Disaster Resistance Features Firewall Cybercrime Screen Reader Emergency Return on Investment Remote Computing Comparison Licensing Options Modem High-Speed Internet Printer Politics Regulation Twitter Education CEO Printers Students Marketing Daniel Stevens

Latest Blog

Downtime is a major problem for businesses, and it’s largely a result of technology taking over the workplace. Since many jobs rely on technology to be done properly, it stands to reason that broken-down technology can pose a considerable issue for businesses--not to mention...

Latest News

We are proud to announce that 415 IT and our CEO, Daniel Stevens, were recently featured by CIO Applications. We discussed how and why we serve our clients, as well as some sneak peeks for our future. Read our interview by visiting:  https:...