LiveChat Live Help
Contact us today!
(248) 218-5018
facebooktwittergooglelinkedinyoutubeExpetec Technology Services RSS Feed

Expetec Technology Services Blog

Expetec Technology Services has been serving the Troy area since 2005, 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.



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

Captcha Image

Blog Archive

Sign Up for Newsletter

  • First Name *
  • Last Name *

      Free Consultation

      Sign up today for a
      FREE Network Consultation

      How secure is your IT infrastructure?
      Let us evaluate it for free!

      Sign up Now!


      Tag Cloud

      Security Tip of the Week Privacy Technology Best Practices Cloud Internet hackers Business Computing Productivity malware Business IT Support Backup Microsoft Email Software Network Security Data IT Services Hardware Efficiency Hosted Solutions Managed Service Provider User Tips Mobile devices Mobile Device Management Computer Disaster Recovery Workplace Tips Google Business Management Microsoft Office Smartphone Android Holiday Ransomware Miscellaneous Remote Monitoring The Internet of Things Smartphones Network analytics Virtualization Windows Business Continuity Social Media Operating System Small Business BYOD Remote Computing Collaboration Server VoIP Unified Threat Management Mobile Computing IT Support WiFi Phishing Managed IT Services Passwords Cybersecurity Alert Outsourced IT Big Data Upgrade Windows 10 Save Money BDR Innovation Managed IT Data Management Saving Money Office Gmail communications Firewall Vendor Management apple Facebook History Budget Communication Artificial Intelligence Outlook Productivity Search Internet of Things Lithium-ion battery Managed IT services Employer-Employee Relationship Browser Quick Tips Save Time Information Technology Cost Management Hard Drives Hiring/Firing Content Filtering Best Practice Help Desk Saving Time Hacking IT Management Marketing App Bandwidth Automation Encryption Recovery Running Cable Wireless Technology Proactive IT Windows 10 Money Update Customer Service Document Management Mobility Bring Your Own Device IBM Hard Drive Tech Support Apps Two-factor Authentication Word Data Backup Law Enforcement Data Recovery Data storage Intranet User SaaS Office 365 Project Management Gadgets Hosted Solution Robot Networking Disaster tablet Cybercrime IT Consultant Antivirus Spam Health iphone Business Growth Monitors Excel Retail Scam Going Green Software as a Service Google Maps Government Laptop Solid State Drive Documents PowerPoint Cloud Computing Mobile Device Flexibility Legal Cryptocurrency Downtime Social Networking Website Travel Access Control Computing Infrastructure Current Events Company Culture avoiding downtime End of Support Phone System Administration Data Security Telephone Systems eWaste Wireless Net Neutrality Patch Management Google Docs Specifications Virus Bitcoin Compliance Chrome Experience VPN Education Presentation Telephony Safety Digital Social Virtual Desktop Maintenance Risk Management Training DDoS Network Congestion Programming Unified Threat Management Business Intelligence Heating/Cooling Start Menu YouTube IT service Password Comparison Uninterrupted Power Supply Unified Communications Cortana Computers Websites Fiber-Optic Shortcut IP Address Data Protection Google Calendar Settings Permissions Public Cloud Assessment Windows 7 Fraud Google Wallet Displays Troubleshooting Augmented Reality Knowledge Corporate Profile Technology Tips switches Processors Consultation Freedom of Information Trending email scam Drones CIO Upgrades LinkedIn Business Owner Skype Tech Terms VoIP How To PDF Human Resources Bata Backup News Vulnerabilities Cabling User Error Computer Repair Competition Inbound Marketing USB Capital Mobile Technology IT consulting Cleaning Co-Managed IT Entrepreneur Vendor Mangement Fake News Business Cards Worker Sports Application Domains Product Reviews Productuvuty Mobile Payment Windows XP Society Sync Router Business Mangement Microsoft Excel Pain Points Licensing Writing Customer Relationship Management Data Loss Electricity Television Windows 8 Hack Environment Digital Signature Statistics Redundancy Office Tips HIPAA Social Engineering Entertainment Teamwork Data Breach WannaCry Mouse Google Drive Blockchain Printer Distributed Denial of Service Online Currency Micrsooft Regulations LiFi SharePoint Time Management Tip of the week Emails Staffing Gaming Console Emergency Audit Content Management Computing Visible Light Communication Best Available Access Evernote Virtual Assistant Music Computer Care Public Speaking Vulnerability Deep Learning Printing Advertising File Sharing Value Spyware Data Warehousing Read Touchscreen Hard Drive Disposal Black Market Securty Computer Accessories Keyboard Storage Hacker Risk Mangaement Business Technology Downloads Archive Streaming Media Bluetooth Politics Electronic Payment Cache Windows Server 2008

      Top Blog

      Don't be Afraid to Replace Got an older PC that's causing you a lot of issues? Older technology is typically more expensive to run, and after a while, it's cheaper to simply buy a new desktop than it is to continue pouring money into something that always seems broken. It's a great time to buy wo...