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
Friday, October 19, 2018

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

Newsletter Sign Up