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

Latest Blog

Technology doesn’t last forever, and this is especially true for software solutions. Granted, software is a little easier to upgrade than hardware, as they can be administered patches and updates remotely, but what happens after that support ends? Well, it turns out that the...

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