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, August 17, 2018

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

Newsletter Sign Up