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
Sunday, August 18, 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Security Tip of the Week Technology Best Practices Privacy Internet Business Computing Cloud Software Business Management Hackers Data Microsoft Hardware Workplace Tips Backup Managed Service Provider Productivity Network Security Business Hosted Solutions Email Malware Saving Money IT Services Efficiency Computer IT Support Google User Tips Productivity Small Business Innovation Smartphones Quick Tips Mobile Devices Microsoft Office Business Continuity Gadgets VoIP Social Media Collaboration Data Backup Network Android Data Recovery Disaster Recovery Mobile Office Server Upgrade IT Support Communication communications Virtualization Smartphone Miscellaneous Mobile Device Management Phishing Windows 10 Windows Tech Term Cybersecurity Ransomware Facebook Operating System Unified Threat Management Vendor Management Remote Monitoring Passwords Apps Automation Holiday Mobile Computing Analytics Users BYOD Remote Computing Managed IT services BDR Mobile Device Outsourced IT Internet of Things WiFi Data Management The Internet of Things Marketing Managed IT Services Artificial Intelligence Apple Firewall History Browser Save Money Alert App Big data Spam Office 365 Help Desk Two-factor Authentication Cloud Computing IT Consultant Encryption Content Filtering Windows 10 Going Green Bring Your Own Device Maintenance Antivirus Printer Gmail Bandwidth Business Technology Office Health Best Practice Information Technology Lithium-ion Battery Cost Management Windows 8 Outlook Hiring/Firing Hard Drives Training Budget Wireless Technology Computers Saving Time Tech Support Search VPN Virus Managed IT Government Employer-Employee Relationship Cybercrime Hacking Networking Information IBM Money Document Management Healthcare Access Control Customer Service It Management Travel Blockchain Education Managed Service Recovery Update Phone System Current Events Password Value Legal Save Time Downtime Regulations Augmented Reality PowerPoint Running Cable Proactive IT SaaS Humor File Sharing Administration Hard Drive Law Enforcement Applications Intranet Twitter Compliance Mobility Website Data Loss Data storage Avoiding Downtime iPhone Risk Management Data Breach Laptop Private Cloud Cortana Business Growth 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 Wireless Data Security Securty Windows 7 Google Maps DDoS Patch Management Solid State Drive Storage Social Engineering Scam Black Market Flexibility Cryptocurrency Word Retail Memory 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 Processor Bitcoin Programming Identity Theft Statistics Network Congestion Documents Data Protection IT service Entertainment Teamwork Heating/Cooling Distribution Virtual Reality Downloads Politics Bluetooth Streaming Media Conferencing Automobile Inbound Marketing Emails Chromebook Voice over Internet Protocol Redundancy Computing Infrastructure Hack Visible Light Communication Proxy Server Azure VoIP UTM Content Rental Service Meetings Public Speaking Modem Touchscreen News 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 Display Technology Tips Business Managemenet Accountants Webinar A.I. Books Workers Fake News Advertising Flash Environment Dark Web Free Resource 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 Business Owner Logistics Emergency Hard Drive Disposal Society Network Management Managed IT Service Saving ZTime Wasting Time Access Displays Equifax Fleet Tracking Reading Samsung 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 Managing Costs Spyware Mobile Payment Skype Startup Asset Tracking Permissions Language Unified Threat Management Backup and Disaster Recovery Microserver Sync External Harddrive Browsers Electricity Printing Username Medical IT 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 Employees WannaCry Upgrades HTML Printer Server LiFi Analytic Telephone System PDF SQL Server Corporate Profile Recycling Mobile Security Trojan GDPR Time Management Freedom of Information Organize Cost Scalability Adminstration Integration Pirating Information Software License Trends Motion Sickness Best Available Keyboard Tech Leadership Assessment SharePoint Product Reviews Multi-Factor Security Tip of the week Work/Life Balance Read Fraud Tactics Fileless Malware Hybrid Cloud Google Calendar Deep Learning Devices Messenger Tracking Domains 3D Printing Capital Personal Information Productuvuty Financial Virtual Machine Printers Managing Stress Hypervisor CrashOverride Regulation

toner1