Computerware

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?
 

Comments

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

hp supplies medallionLarge2017