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

Latest Blog

It’s just good business to hand out your business card to prospective clients, and it has been for a very long time. As far back as the Renaissance, special guests were announced with name cards that displayed who the guest was and what types of greetings were due. It wasn’t...

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.