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
Wednesday, January 16, 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

Newsletter Sign Up