Our Most Popular Managed Services

If you need help deciding what services are best for your business let us know.

Logo

 
 Popular Services
 (347) 830-7322

Logo

 

Tekie Geek Blogs

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...
You Should Care About Blockchain Technology
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Monday, 28 May 2018

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

VoIP Virus Society Google Drive Network Vendor Mangement Startup Unified Threat Management Downloads IT consulting company Sports How To Tip of the week Bluetooth Workplace Tips Device security HTML Tracking Compliance Facebook staten island managed services Miscellaneous Downtime Automobile Staten Island IT support Backup and Disaster Recovery Running Cable Bring Your Own Device News Microsoft Hard Drive 3D Printing Website computer repair Time Management Mobile Device Management Training Machine Learning Settings Robot Scalability Computing Infrastructure Search Domains Administration Deep Learning BDR computer support firms Cabling managed services Antivirus email scam VoIP Banking Memory Office 365 Best Practice end-user files File Sharing Social Engineering Hacking Accidental deletion Operating System Download Virtual Desktop Quick Tips Computer Virtual Reality Unified Communications Tech Terms Text Messaging BYOD Network Management Automation Cloud computing Staten Island Security Microchip Legal Efficiency Cybersecurity LiFi Conferencing Apple Project Management Business Continuity VPN Vulnerability Multi-Factor Security Screen Reader Safety Data In Internet of Things Lithium-ion battery App Communication Software as a Service Regulations Productivity data recovery Documents Staffing Employer-Employee Relationship computer repair Staten Island managed IT services staten island User Tips Hackers Equifax Networking Laptop Alert Telephony Lenovo Remote Monitoring Cost Management Worker Money Hacks ransomware attacks Data Management Outlook IT support firms Phishing Streaming Media IT consulting Staten island today ’s organizations Android Solid State Drive IT support Paperless Office it support Outsourced IT Patch Management IT consulting firm Cloud Computing Windows Tactics Work/Life Balance Document Management Advertising Emails Gadgets tech support Staten Isalnd Vulnerabilities Managed IT Bitcoin Cortana Comparison tech support Administrator Chromebook Managed IT Services Wireless Windows 8 Corporate Profile Computer Malfunction malware Hard disk Spyware Addiction Hosted Solutions Microsoft Office Piracy Company Culture Computing Privacy Google Wallet Maintenance Budget Emergency Fake News Business Cards Printer Spam Customer Service IT consulting NYC Recovery Telephone Systems Web Server IT support NYC data recovery Staten Island Malware Firewall Smartphone IT Support Television computer support Staten Island tech support Staten Island IT support New York City Visible Light Communication YouTube Virtualization SaaS Innovation Passwords Politics Nanotechnology Thank You Flexibility Public Cloud History Bandwidth Data Backup Law Enforcement Wi-Fi Google Language Audit Hardware eWaste IT support Staten Islans Staten Island IT consulting Digital Payment The Internet of Things Ransomware Two-factor Authentication Remote Computing Staten Island tech support data loss Hard Drive Disposal Business Mangement Identity Theft Technology Scam Botnet Password Internet of Things Cleaning Disaster Recovery Proactive IT Displays Google Calendar Tech Term Social Media CrashOverride communications Meetings Multi-factor Authentication IT support Staten Island CryptoLocker Legislation Upgrade IT consulting G Suite IT services Staten Island Access Control PDF Help Desk Windows 10 Specifications Staten Island computer support Microsoft Excel Samsung Tech Support computer support Wireless Headphones Cloud Database Black Market Websites Business Technology Devices Cybercrime Analytics Holiday Productivity Smartphones Software Network Congestion Virtual Assistant Managed Service Provider Business Metrics Server Hack Mobile Device Apps Knowledge IBM Relocation Data Protection Travel Notifications malware worms Hosted Solution WiFi Augmented Reality CCTV Webcam Google Docs IT consulting firms Data Security Accountants Blockchain Business Freedom of Information Cache Software License Desktop Cryptocurrency Word Business Computing Mouse Congratulations Mobile Devices Supercomputer Best Practices Taxes Disaster Hiring/Firing Tablets Laptops Redundancy Small Business Wireless Technology IT Management Securty Workers Health Artificial Intelligence Service Level Agreement Motion Sickness IT Services Touchscreen Music Saving Money IT consulting Staten Island Office Big Data Retail Google Maps Email Computer Care managed IT services NYC Drones Update Government Education End of Support Office Tips Network Security Windows XP Computers Managed IT Services IT services New York City Twitter Collaboration SharePoint Physical Security Writing DDoS Tip of the Week Private Cloud Monitors Mobility Business Management IT Consultant Information Technology Applications Data Breach managed it services Data storage Printing Access Excel Internet Content Filtering Uninterrupted Power Supply Encryption computer services Start Menu Powerful Technology Solutions Digital Flash Backup Windows 10 computer services Staten Island Tablet Processors Reliable Computing datto Employer Employee Relationship Gmail Workstations Hacker computer support NYC Vendor Management Distributed Denial of Service Social managed services Staten Island Mobile Technology Save Money Hardware Solutions Business Growth Unified Threat Management IT services NYC Experience Rental Service Browser Mobile Security

Newsletter Sign Up