Network Technologies of Kansas Blog

Network Technologies of Kansas has been serving the Topeka 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, 16 September 2019

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Security Tip of the Week Best Practices Internet Technology Privacy Email Hackers Cloud Malware Software Business Business Computing Microsoft Computer Productivity Upgrade Google Hardware Backup Network Security User Tips Hosted Solutions Workplace Tips Small Business Bandwidth Social Media Smartphone Gmail Ransomware The Internet of Things Operating System Efficiency Mobile Devices IT Support Networking Apple Best Practice Windows Communication Apps Innovation Content Filtering BDR Money Safety Data storage Website Quick Tips Windows 10 Passwords Data Disaster Recovery Android Hacking Mobile Device Management Microsoft Office Saving Money Big Data Two-factor Authentication Business Continuity Smartphones Outlook Facebook WiFi Alert Deep Learning Remote Computing Bluetooth Holiday Document Management Network Law Enforcement Office Running Cable Firewall Gadgets Memory Downtime Lithium-ion battery Education Customer Service Network Congestion Vendor Management Documents Save Money Proactive IT YouTube Wireless Technology LiFi Monitors App Cryptocurrency Data Recovery Phishing Music Streaming Media Visible Light Communication Google Docs Displays Cleaning Domains Sports Search Advertising Analytics History BYOD Cybercrime Internet of Things Black Market Office Tips Information Technology Mobile Computing End of Support Securty Spam Compliance Business Growth Micrsooft Experience Artificial Intelligence Writing Society Browser Google Wallet Robot Social IP Address Windows 8 Office 365 Virtual Desktop Encryption Hosted Solution Disaster communications Retail Laptop Tech Support SaaS Hacker Drones Automation Recovery Unified Communications Augmented Reality Managed IT services Printer

Newsletter Sign Up

  • First Name *
  • Last Name *