Voyage Tech Blogs

Voyage Technology has been serving the Beaver Dam area since 1999, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

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.

 

Comments

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

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

Security Tip of the Week Technology Best Practices Hackers Business Computing Email Cloud Privacy Computer Malware Internet Hosted Solutions Innovation User Tips Data Tech Term Network Security Efficiency Software Business Hardware Productivity Mobile Devices Android Business Management IT Services Microsoft Data Backup Communication Social Media Smartphone Google Small Business Data Recovery Smartphones IT Support Browser Productivity communications Server Collaboration Artificial Intelligence Backup Windows 10 Facebook Workplace Tips Microsoft Office Managed Service Provider Upgrade Ransomware Data Management Internet of Things Phishing Two-factor Authentication Cloud Computing Automation Cybersecurity Gmail VoIP App Spam Mobile Device Information Office 365 Windows 10 Saving Money Government Encryption Network Apps Employer-Employee Relationship Users Outsourced IT Applications Passwords Managed Service Windows Office Tips Business Technology Bandwidth Disaster Recovery Managed IT Services Miscellaneous Blockchain Computing Customer Service Vulnerability Computers BDR Website Printer Quick Tips Analytics Access Control IT Support Mobile Device Management Augmented Reality Firewall Business Continuity Infrastructure Tip of the week Paperless Office The Internet of Things Apple BYOD WiFi Scam Big Data Cooperation Holiday Social Going Green Settings Robot Data Security Printing Cost Management Content Filtering Cybercrime End of Support Wi-Fi HIPAA Hacking Presentation Vendor Router Hacker Risk Management Office Wireless Technology Modem IT Management Mobile Security Avoiding Downtime Data storage LiFi Mobile Office Money Chrome Saving Time Healthcare Storage Sports Retail Downloads Mouse Safety Bring Your Own Device Administration Managed IT Services Antivirus Networking Document Management Maintenance Gamification Microsoft 365 Staff Tech Support Cortana Google Play Telephone System Social Networking Alt Codes Identity Theft Data loss Customer Relationship Management Downtime Save Money Wireless Fileless Malware Comparison Security Cameras Content Solutions Operating System Patch Management Wearable Technology Hosted Solution Websites Competition Health IT Techology Motherboard Typing Assessment Permissions YouTube Vendor Management Directions Specifications SSID Integration Google Drive Machine Learning Knowledge Network Congestion Unified Threat Management Cryptocurrency Tablet Black Friday Internet Exlporer Information Technology Remote Monitoring Fraud Electronic Medical Records User 5G Microchip Medical IT Username Virtual Assistant Google Docs VPN Unified Communications Private Cloud Experience Running Cable Display User Tip User Error Bitcoin Cyber Monday Database Google Wallet IP Address Virtual Desktop Virtual Reality Processor Transportation Virtual Private Network IT Technicians Error Google Maps Laptop Monitors Proxy Server Cookies Windows 8 Smart Technology Tactics PowerPoint Drones Hotspot Twitter Recovery Marketing Navigation Monitoring Employer/Employee Relationships Outlook Mirgation Hard Drives Domains Halloween Word Help Desk Nanotechnology Distributed Denial of Service Addiction Professional Services Network Management Language Remote Computing Evernote Management Teamwork Humor Chatbots Travel Refrigeration Public Speaking Scary Stories Writing SharePoint Screen Reader Hacks Service Level Agreement Voice over Internet Protocol Budget Computing Infrastructure Lithium-ion battery Alert Fun Entrepreneur Conferencing SQL Server Lenovo Identity Deep Learning Unified Threat Management Managed IT Service Bookmark Smart Tech Password Download iPhone Alerts Education Tech Telephone Azure Superfish Undo Break Fix Social Engineering Browsers Multi-Factor Security Connectivity Mobile Computing Upload Vulnerabilities Server Management Licensing Search Term Social Network Compliance Best Practice Virtualization Dark Web Buisness Entertainment Google Calendar IoT Current Events Trends Windows 7 Legal IT solutions Application Mobility Dark Data Customer Resource management Regulations Business Growth Microsoft Excel IBM How To Gadgets Data Analysis Legislation Star Wars

Sign Up For Our Newsletter!