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
Sunday, 22 September 2019
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Sign Up For Our Newsletter!

Mobile? Grab this Article!

Qr Code

Tag Cloud

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