Get Started Today!  217-475-0226

Decatur Computers Inc. Blog

Decatur Computers Inc. has been serving the Decatur area since 2001, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Using Excel to Excel-lerate

Tip of the Week: Using Excel to Excel-lerate

Microsoft Excel has been around for quite some time, but it’s one of the trickier Microsoft Office solutions to master. You might know all about some of the more common Excel tricks, but do you know these power shortcuts that can help you fully take advantage of the spreadsheet software? Here are some obscure Excel shortcuts that your organization can take advantage of.

However, before we jump into any new keyboard shortcuts, we want to remind you that all of the basic keyboard shortcuts that work in other Microsoft products will still work here. All of the tried and true shortcuts like Copy, Cut, Paste, and Find, will all work here in Excel.

Check Specific Formulas
Excel doesn’t default to showing you the formulas in your cells. Instead, all it will show you is the result of the formula. If you click on a cell, the formula will appear in the formula bar at the top of the spreadsheet. Doing this for each and every one of your cells can be troublesome and time-consuming. You can toggle your spreadsheet between values and formulas by using the Ctrl + ` keyboard shortcut.

Border Your Cells
If you don’t want to waste a bunch of time by finding specific borders for your cells, you can use the default one by pressing the keyboard shortcut for Ctrl + Shift + 7. This surrounds the cells you’ve selected with a simple border.

Remove Cell Borders
To quickly remove borders from your cells, you can use the keyboard shortcut for Ctrl + - (minus). It’s a quick solution to fix borders that didn’t turn out the way you wanted them to.

Select an Entire Row or Column
You can select an entire row by clicking the first cell in the row and using the Shift + Spacebar shortcut. The same function for columns can be accomplished by using the Ctrl + Spacebar shortcut.

Format an Object or Chart
If you’ve inserted an object or chart into your spreadsheet, Excel makes it easy to format it. You can use the keyboard shortcut to bring up a dialogue box that contains all of the proper formatting tools you’ll need to succeed. The shortcut is Ctrl + 1.

What are some of your favorite Microsoft Excel shortcuts? Leave them in the comments.

What Every SMB Should Know When Selecting an IT Se...
You Should Care About Blockchain Technology
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Sunday, June 24 2018
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

Tip of the Week Security Best Practices Privacy Technology Network Security Hackers IT Support Business Computing Cybersecurity Tech Term Android Google Smartphone Business Management Malware User Tips Internet Software Backup Email Small Business Managed IT Services Ransomware Data Recovery Innovation Productivity Artificial Intelligence Data Windows 10 Phishing Communications Cost Management IT Management Business Cloud Cybercrime Data Backup Efficiency Business Technology Network Computer Hard Drive Update Outsourced IT Managed IT Services Saving Money App Blockchain Hardware Data Security Encryption IT Services Gadgets Antivirus Mobile Device Management Collaboration Patch Management Laptop Microsoft Data Breach Office 365 Websites Start Menu Law Enforcement Passwords Browser Applications Smartphones Tech Terms Business Continuity Project Management Data Management Internet of Things Access Control Bitcoin Disaster Recovery Social Engineering Data Protection Windows BDR Gmail Alert VPN Vulnerabilities Automation Server Operating System Apps Bandwidth Facebook Maintenance Holiday Remote Monitoring Microsoft Office SaaS Spam Word Money Search Digital Social Media Data loss Document Management Hacking Touchscreen Save Money Mobile Device Scam Backup and Disaster Recovery Going Green Unified Communications Hard Drive Disposal Redundancy Spyware Compliance Budget Bluetooth Piracy Knowledge Specifications Running Cable Tablet Download Printing Microsoft Excel Software as a Service email scam Solid State Drive Analytics WiFi Regulations Wireless Headphones Software License Television Telephone Systems Cabling How to IT Support Printer Upload Mobile Security Government Cryptocurrency Mobile Devices Wireless Accountants Comparison Cleaning Mouse Google Drive Consultant Paperless Office Trends Two-factor Authentication Legal Virus eWaste Managed Service Provider Uninterrupted Power Supply Big Data Training Computers Information Technology Google Maps Telephony Worker YouTube Database Gamification Multi-factor Authentication Downloads Robot Emergency Equifax Nanotechnology Mobile Technology VoIP Cloud Computing Settings Samsung Tactics Device security VoIp Excel Vulnerability History Unified Threat Management Startup Augmented Reality Audit SharePoint Administration Addiction Content Website Mobility Tip of the week Computing Infrastructure DDoS IBM Corporate Profile Automobile Screen Reader Virtual Reality Distributed Denial of Service Time Management Hosted Solutions Managed IT Machine Learning Legislation Networking Password Best Practice Communication Company Culture Computer Care Freedom of Information Employer-Employee Relationship Cortana HTML Google Calendar Virtualization Business Cards Unsupported Software Conferencing Network Management Identity Theft News Unified Threat Management Virtual Assistant Outlook Apple Disaster Vendor Mangement Chromebook Service Level Agreement Desktop Fake News Access Devices Google Docs Emails Downtime Business Mangement Upgrades Windows 10 Twitter Marketing Managing Stress Multi-Factor Security CrashOverride BYOD Office Users Office Tips

Latest Blog

IT support is one of the most important parts of any modern business simply because it’s just not feasible to run a business without any form of technology at its core. For example, most businesses rely on email and other forms of communication, whereas stores might require ...

Latest News

Decatur Computers Inc. is proud to announce the launch of our new website at http://www.decaturcomputers.com. The goal of the new website is to make it easier for our existing clients to submit and manage support requests, and provide more information about our services for prospective clients.