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

Tekie Geek has been serving the Staten Island, Brooklyn, Queens, Bronx, New York City, Long Island and New Jersey area since 2012, 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.

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Sunday, 25 February 2018

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

Newsletter Sign Up