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...
Have You Heard of Evernote for Your Business?


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

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Security Tip of the Week Technology Best Practices Privacy Internet Cloud Business Management Software Microsoft Business Computing Hackers Backup Managed Service Provider Workplace Tips Productivity Data Hardware Business Saving Money Malware Email IT Support IT Services Hosted Solutions Network Security Google Efficiency Small Business Smartphones Gadgets Quick Tips User Tips Mobile Devices Business Continuity Computer Disaster Recovery Mobile Office Virtualization Network Android Innovation Microsoft Office Server VoIP Mobile Device Management Social Media Smartphone Upgrade Windows 10 Miscellaneous Ransomware Unified Threat Management Windows Remote Monitoring Operating System Mobile Computing BYOD Remote Computing Collaboration Communication Passwords Holiday Cybersecurity Managed IT services WiFi Vendor Management Apps IT Support Marketing Facebook Data Backup The Internet of Things Data Recovery History Users Apple Analytics Firewall Automation Tech Term BDR Productivity Data Management Internet of Things communications Alert Artificial Intelligence Managed IT Services App Save Money IT Consultant Outsourced IT Phishing Gmail Big data Spam Content Filtering Health Going Green Mobile Device Bandwidth Office Bring Your Own Device Windows 8 Budget Managed IT Outlook Wireless Technology Antivirus Search Encryption Maintenance Printer Tech Support Virus Browser Cybercrime Hiring/Firing Best Practice Information Technology Hard Drives Lithium-ion Battery Cost Management Update Recovery Money Employer-Employee Relationship Document Management IBM Phone System Hacking Computers Travel Office 365 Help Desk Compliance Windows 10 Administration Hard Drive Data storage Risk Management Customer Service Two-factor Authentication Humor Cloud Computing Government Website Save Time Legal Networking Regulations Proactive IT It Management Running Cable SaaS Business Technology Saving Time Training VPN Intranet Law Enforcement Education Solid State Drive Data Breach User Fax Server Black Market Flexibility Project Management Mobility Wireless Laptop Business Intelligence Social Engineering DDoS Avoiding Downtime Business Growth Digital Payment Applications Downtime Access Control iPhone Word Comparison Tablet Paperless Office Company Culture Password Cortana Data Security Computer Repair Excel Disaster Social Networking Customer Relationship Management Current Events Hosted Solution Telephone Systems Hacker End of Support Patch Management Blockchain Data Loss Augmented Reality Robot Securty Twitter PowerPoint Text Messaging Identity Theft Streaming Media Webcam Lifestyle Virtual Desktop Specifications Safety Vulnerabilities Bluetooth Google Maps Social Digital Healthcare Politics Documents Cryptocurrency Net Neutrality Virtual Reality Websites Start Menu Tech Terms Chrome Automobile Heating/Cooling Google Docs Emails Experience Mobile Technology Inbound Marketing Chromebook Storage Cleaning Computing Infrastructure Hack Monitors Software as a Service Router Uninterrupted Power Supply Computer Accessories How To Office Tips Pain Points Private Cloud Download Retail eWaste Trending YouTube Bitcoin Unified Communications Settings Data Protection Mouse Value Sports Telephony Machine Learning Taxes Computing Statistics Distributed Denial of Service Programming Processors User Error Network Congestion Co-managed IT Scam Gaming Console Public Cloud USB IT service Presentation Redundancy File Sharing Human Resources Migration Connected Devices VoIP Recycling GPS Sync Application Wireless Headphones Upgrades Touchscreen News Analytic Knowledge Equifax Consultation Evernote Product Reviews External Harddrive Notifications CCTV LiFi Network Management Reliable Computing Device security Technology Tips Business Metrics Computer Malfunction Virtual Assistant Read Desktop Finance Work/Life Balance Audit 3D Ebay Best Practives In Internet of Things Digital Signature Nanotechnology Deep Learning Fake News Thin CLient Visible Light Communication Service Level Agreement Memory Device Management Teamwork Startup Data Warehousing Smart Phones Entertainment Business Cards Microserver Scalability Access Business Managemenet Motion Sickness Unified Threat Management IT consulting Backup and Disaster Recovery Emergency Content Management Hard Drive Disposal Messenger Tracking PDF Gamification Computer Care Adminstration Pirating Information Screen Reader Microsoft Excel Leadership Piracy Advertising Upload Flash online Currency Get More Done Best Available Keyboard CIO Smart Tech Google Drive Windows Server 2008 Rental Service Meetings Turn Key Cabling Staffing HTML Google Wallet Spyware Mobile Payment Printer Server Web Server Domains Fiber-Optic Windows XP Database Vulnerability Books Workers Mobile Security Society Electricity Printing LinkedIn Trojan Wi-Fi Administrator Public Speaking Conferencing Displays Supercomputer Software License Trends Shortcut Multi-Factor Security Micrsooft Windows 7 Organize Upselling Worker Entrepreneur Devices Drones cache Television Skype Microchip Troubleshooting Fraud Tactics Archive Reading Samsung Environment UTM Content WannaCry Downloads Video Surveillance HIPAA Monitoring Employer Employee Relationship Electronic Payment IT Plan Permissions Enterprise Resource Planning Language Corporate Profile G Suite Competition Legislation Time Management Point of Contact Freedom of Information Saving ZTime Licensing Accountants Assessment SharePoint Webinar Hacks Physical Security Business Owner email scam Addiction Harddrive Relocation Tablets Multi-factor Authentication Music Information Google Calendar Debate Banking Botnet IP Address switches Management Writing Tip of the week MSP Capital Username 3D Printing Productuvuty Managing Stress CrashOverride