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.

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Wednesday, 17 January 2018

Captcha Image

Request a Free Consultation

  • Company name *
  • First Name *
  • Last Name *
  • Title
  • Phone
  • What are your concerns?

      Sign up for our Newsletter!

      • Company *
      • First Name *
      • Last Name *

          Mobile? Grab this Article!

          QR-Code dieser Seite

          Tag Cloud

          security Tip of the Week technology Best Practices Cloud Privacy Hackers Productivity Business Computing business Malware Microsoft Internet IT Services Backup Hosted Solutions Managed Service Provider IT Support Email Workplace Tips Network Mobile Devices Hardware Communication Computer Smartphones Microsoft Office Disaster Recovery Holiday Windows Miscellaneous Mobile Device Management Small Business Business Continuity Windows 10 network security Efficiency Data Server Smartphone Alert Saving Money Business Management User Tips Virtualization Software Google Upgrade Social Media WiFi Operating System Internet of Things Big Data Android Gmail Ransomware BYOD Passwords VoIP Remote Computing Mobile Computing The Internet of Things App Cybersecurity Office Innovation Browser Apple Vendor Management Spam Remote Monitoring Apps Business Growth Risk Management Analytics Phishing Facebook Wireless Technology Artificial Intelligence Collaboration Budget Going Green Hacker Customer Service Automation Robot Outsourced IT Money Gadgets Office Tips Managed IT Services Data Management Retail Best Practice IT Solutions Information Technology Tech Support Office 365 Bring Your Own Device Save Money End of Support Health Hard Drives Cortana Employer-Employee Relationship Outlook Document Management Cost Management Managed IT Application Mobile Device Presentation Firewall Computers Hacking Content Filtering Proactive IT Current Events Running Cable Lithium-ion Battery Avoiding Downtime Customer Relationship Management virus Hosted Solution Bitcoin IT service IT Consultant Saving Time Data storage Recovery VPN Social Chrome Twitter USB PowerPoint LiFi Samsung Statistics Password Save Time Quick Tips Excel Safety Antivirus Hiring/Firing Tablet iPhone Social Engineering Mouse Downtime Encryption project management Business Owner intranet Competition Website Wireless Net Neutrality Settings eWaste Work/Life Balance Search Bandwidth Humor Update Trending Maintenance Virtual Desktop Law Enforcement IT Support Education Administration Cryptocurrency Analyitcs Network Congestion Programming Marketing Specifications Disaster Google Docs User Two-factor Authentication communications Hacks Cybercrime Laptop Phone System Windows 8 Printing Computing Infrastructure Fun cyberattacks Training Storage Distributed Denial of Service Data loss Modern technology Digital Display Computing Vulnerability businesses Entrepreneur Documents Processors File Sharing Digital Signature Online Currency Dark Data Buisness Evernote Mobility Refrigeration IP Address IT Management business owners Deep Learning Virtual Assistant Monitors Crowdfunding Google Wallet Networking Knowledge Software as a Service PDF Notifications Files Flexibility CIO Data Warehousing Mobile Office Google Calendar Company Culture Hard Drive Windows 8.1 Update Writing Drones Business Cards Printer Experience Technology Tips Co-managed IT Telephone Systems Websites User Error Windows Server 2008 Access Control Productivity Help Desk Identities Data Security Printer Server Mobile Technology Crowdsourcing Botnet today ’s world Windows 7 Undo Hard Drive Disposal Users Solid State Drive Backups Mobile Payment Word Government experience downtime Debate YouTube Freedom of Information Alt Codes Unified Threat Management Data Breach Consumers Skype Compliance Memory Legal Patch Management Domains News LinkedIn Typing Fiber-Optic Wi-Fi Downloads Travel Computer Repair Regulations bdr Comparison Environment Public Speaking Private Cloud Router Paperless Office Fake News Best Available Fraud 5G data breaches Business Intelligence History People Google Drive Halloween Television Heating/Cooling Troubleshooting Gadget IBM Managed IT Services Microsoft Excel Video Surveillance email scam risk Touchscreen Scary Stories Cyber-attacks Politics Public Cloud Licensing Blockchain Vulnerabilities Augmented Reality cyberattack Black Market Telephony Managed Service Providers Sports SharePoint security breach Piracy Unified Communications Tip of the week Staffing Unsupported Software Administrator Taxes Mobile Data Data Backup Sync Web Server Supercomputer Cloud Computing Mobile Device Managment Cameras IT Budget Cabling CCTV Digital Payment Infrastructure test post G Suite Virtual Reality Point of Sale Uninterrupted Power Supply Machine Learning Google Maps Unified Threat Management SaaS Meetings Hard Disk Drive Relocation Physical Security Software Tips Webcam Motion Sickness Chromebook How To GPS Error Personal Information Cleaning Emoji Upgrades Tracking Corporate Profile Electronic Medical Records Computer Care 3D Printing Identity Theft WannaCry Automobile