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


No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Saturday, 17 March 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 Privacy Best Practices Business Computing Network Security Hackers IT Support Malware Cybersecurity Small Business Managed IT Services User Tips Ransomware Google Software Backup Technology Email Business Management Android Productivity Smartphone Internet Windows 10 Efficiency Phishing Communications Data IT Management Cloud Cybercrime Data Recovery Gadgets Data Security Artificial Intelligence Antivirus Mobile Device Management Cost Management Hard Drive Update Hardware Innovation Business Outsourced IT Office 365 IT Services Apps Windows VPN Encryption SaaS Server Money Internet of Things Bitcoin Facebook Search Maintenance Touchscreen Remote Monitoring Save Money Social Engineering Blockchain Microsoft Office Microsoft Data Backup Gmail Law Enforcement Business Technology Passwords Start Menu Vulnerabilities Word Digital Browser Collaboration Patch Management Scam Holiday Data Management Websites Laptop Disaster Recovery Saving Money Network Computer App BDR Data Protection Alert Hacking Business Continuity Project Management Access Control Managed Service Provider Big Data Data Breach Google Maps Hard Drive Disposal Telephony IBM YouTube Hosted Solutions Downloads Piracy Automobile Specifications Emergency Microsoft Excel Applications Best Practice email scam VoIP Settings Employer-Employee Relationship VoIp Software License Television Vulnerability Cryptocurrency Mobile Security Unsupported Software Audit Mobile Devices Administration Mobility Operating System Mouse DDoS Social Media Two-factor Authentication eWaste Time Management Corporate Profile Information Technology Managed IT Password Multi-factor Authentication Upgrades Computer Care Robot Google Calendar Mobile Technology Excel Spam Device security Unified Threat Management Running Cable Document Management Augmented Reality Outlook SharePoint WiFi Disaster Tip of the week Vendor Mangement Solid State Drive Website Telephone Systems Computing Infrastructure Access Cabling Google Docs Virtual Reality IT Support Distributed Denial of Service Tech Term Wireless Business Mangement Consultant Unified Communications Networking Redundancy Freedom of Information Spyware Budget Company Culture Managed IT Services HTML Knowledge Cortana Uninterrupted Power Supply Tablet Printing Business Cards Software as a Service News Analytics Worker Smartphones Identity Theft Tech Terms Virtual Assistant How to Government Fake News Cloud Computing Comparison Desktop Samsung Unified Threat Management Mobile Device Google Drive History Legal Downtime Automation Virus Compliance Regulations Office Users Office Tips CrashOverride Windows 10 Marketing Data loss Devices

Latest Blog

If you’ve ever felt as though someone was watching what you were doing while you were working remotely, either at home or in public, there’s a chance that you were right. Without a private Internet connection, it is a simple matter for others to watch your processes and stea...

Latest News

Decatur Computers Inc. is proud to announce the launch of our new website at 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.