Computerware has been serving the Vienna area since 1976, 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.

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