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