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.

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

Appearance
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
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Wednesday, June 26, 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

toner1