facebook linkedin twitter

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