facebook linkedin twitter

Computerware Blog

Tip of the Week: Excel Tips That Work

Tip of the Week: Excel Tips That Work

Microsoft Excel has a ton of functionality, but how much of it are you actually utilizing? This week’s tip will help you take full advantage of keyboard shortcuts, so you can leverage the solution to the best of your ability.

The most basic Excel formatting you can take advantage of is aligning the values in the cells to the left, right, or center. Here are the 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
Your spreadsheet contents might require specific formatting so their meaning can be effectively conveyed. To assign this formatting, try out the following keyboard 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 are practically necessary when you’re using a spreadsheet, as they can mean more distinction between values. Here are some shortcuts to try for your cell borders:

  • 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+_.

If you thought the previous shortcuts were basic, get a load of these ones. They are the same shortcuts you know and love from various other Microsoft applications.

  • 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 you’ll put this list to good use. You could even print it out so that it’s more accessible. Why not distribute it to the employees in your office while you’re at it?

Do you have any suggestions for tips you want to see covered in future articles? Leave them in the comments below and be sure to subscribe so you don’t miss a beat.

VoIP Has a Spam Problem
Employers Aren’t the Only People with Expectations


No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Tuesday, May 26, 2020

Captcha Image

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

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Security Tip of the Week Technology Best Practices Privacy Business Computing Internet Cloud Software Business Management Data Hackers Hardware Microsoft Network Security Workplace Tips Backup Hosted Solutions Managed Service Provider Business Productivity Email Productivity Malware IT Services Saving Money Efficiency Google Computer User Tips Innovation Small Business IT Support VoIP IT Support Data Backup Collaboration Smartphones Quick Tips Mobile Devices Network communications Business Continuity Microsoft Office Gadgets Social Media Android Data Recovery Cybersecurity Upgrade Disaster Recovery Communication Mobile Office Server Smartphone Virtualization Mobile Device Management Miscellaneous Phishing Vendor Management Holiday Ransomware Operating System Windows 10 Windows Passwords Tech Term Outsourced IT Internet of Things Unified Threat Management Managed IT Services Mobile Device Remote Monitoring Apps Facebook Users Automation BDR BYOD Remote Computing Apple Managed IT services Data Management Mobile Computing Analytics Windows 10 WiFi Cloud Computing Artificial Intelligence Marketing The Internet of Things History Save Money Firewall Training Browser App Alert Encryption Big data Help Desk Bandwidth Health IT Consultant Office Information Technology Office 365 Business Technology Two-factor Authentication Spam Cybercrime Managed IT Content Filtering Going Green Access Control Windows 7 Budget Bring Your Own Device Gmail Antivirus Maintenance Government Hard Drives Printer Tech Support Employer-Employee Relationship Virus Retail Managed Service Computers Saving Time VPN Cost Management Lithium-ion Battery Best Practice Information Windows 8 Outlook Healthcare Wireless Technology Hiring/Firing Search Recovery Project Management iPhone Hacking Travel Education Phone System Update IBM It Management Networking Augmented Reality Blockchain Customer Service Data Loss Money Document Management Computing Humor Computer Repair Running Cable Proactive IT Law Enforcement Avoiding Downtime File Sharing Hard Drive Conferencing Value Compliance Password Solid State Drive Data storage Intranet Twitter Mobility Hacker Flexibility Covid-19 Current Events Customer Relationship Management Risk Management Data Security Legal PowerPoint Patch Management Save Time Regulations Downtime Wireless Administration Storage Website SaaS Data Breach Applications Robot Cooperation Securty Vendor Digital Social Networking Word Websites Google Maps Remote Work Cortana Software as a Service Monitoring Social Engineering Black Market Excel Cryptocurrency Laptop Management Meetings Business Growth Private Cloud User Net Neutrality Voice over Internet Protocol Wi-Fi Vulnerabilities Business Intelligence Virtual Desktop Fax Server Telephony Digital Payment Social Machine Learning Router Paperless Office Sports Scam Telephone Systems DDoS Comparison Tablet Disaster Company Culture End of Support Hosted Solution Distribution Mouse Evernote Virtual Assistant Identity Theft IT service Inbound Marketing Programming Processor Statistics eWaste Network Congestion Start Menu Tech Terms Virtual Reality Pain Points Bluetooth Mobile Technology Politics Automobile Emails Streaming Media Uninterrupted Power Supply Chromebook Processors Professional Services Google Docs Co-managed IT Vulnerability Computing Infrastructure Hack Memory User Error USB Integration Bitcoin How To Presentation Multi-factor Authentication Experience Telephone Monitors Data Protection Download Cleaning Office Tips Specifications Chrome Safety Gaming Console Smart Devices Managed Services Provider Lifestyle Downloads Webcam YouTube Microchip Taxes Documents Text Messaging Heating/Cooling Computer Accessories Distributed Denial of Service Entertainment Unified Communications Settings Teamwork Employee/Employer Relationship Redundancy Managed Services Public Cloud Licensing Managed IT Service Trending Relocation Best Available Tablets Keyboard Smart Phones Smart Tech Bookmark Knowledge Banking Botnet Internet Service Provider Piracy Upload Permissions Language Cyber security Consultation Employer/Employee Relationships Sync Archive IT Assessment Domains Fiber-Optic Database Google Play Telephone Service Get More Done Technology Tips Skype HTML Printer Server Fake News Public Speaking Leadership Telephone System switches Writing Managing Costs Turn Key Audit Notifications CCTV Remote Working Adminstration Mobile Security Pirating Information Music Microsoft 365 Reliable Computing Point of Contact Shortcut Multi-Factor Security Cost Upgrades Browsers Business Metrics Computer Malfunction Software License Trends Medical IT Trend Micro Trojan Data Warehousing User Tip Proactive Maintenance Organize Emergency Hard Drive Disposal In Internet of Things Troubleshooting Electronic Health Records Fraud Tactics LiFi Security Cameras Threats Access Entrepreneur Devices Solutions Microsoft Excel HIPAA Memes Navigation Virtual Machine Computer Care Environment UTM Content Windows Server 2008 Scalability Competition Analytic Legislation Error Deep Learning Data Analysis Employees Recycling Motion Sickness Electronic Payment Managing IT Services IT Plan Enterprise Resource Planning Work/Life Balance eCommerce Google Drive A.I. SQL Server Business Owner Surveillance Upselling email scam Addiction Visible Light Communication GDPR Managing Risk Spyware Mobile Payment Messenger Tracking Product Reviews Accountants Webinar IT IP Address Read IT consulting Tech Hypervisor Electricity Printing Rental Service Remote Workers Video Surveillance Cabling Application Saving ZTime Wireless Headphones Fileless Malware Hybrid Cloud Web Server Virtual Private Network Human Resources Migration Connected Devices Holidays Equifax Fleet Tracking CIO Proxy Server Azure Device Management Administrator Development Network Management Advertising Flash Modem Strategy cache Television Books Workers Electronic Medical Records Transportation Content Management Harddrive Windows XP Term WannaCry Supercomputer Business Managemenet Device security Debate MSP Staffing Google Wallet Time Management Freedom of Information Digital Signature Worker Nanotechnology Social Network Displays Directions Display Corporate Profile Procurement GPS Desktop Finance Society Recording Optimization External Harddrive Startup Asset Tracking Micrsooft Dark Web Free Resource online Currency Video Conferencing Business Cards Service Level Agreement SSID How To Best Practives Assessment SharePoint Reading Samsung Health IT Tip of the week G Suite Communitications Unified Threat Management Backup and Disaster Recovery Processing Google Calendar Employer Employee Relationship Username Drones Touchscreen News Thin CLient Screen Reader Customer Resource management Wasting Time Microserver VoIP Hacks Physical Security PDF LinkedIn Supply Chain Management 3D Ebay Gamification Logistics Virtual Machines Personal Information Capital Managing Stress Financial Regulation Productuvuty Printers 3D Printing CrashOverride