Our Blog: Stuff we think you should know

Haber Group has been serving the New York area since 2000, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Excel-lent Keyboard Shortcuts

Tip of the Week: Excel-lent Keyboard Shortcuts

How well do you know Microsoft Excel, the premier spreadsheet building software? Depending on your proficiency with it, you may already be familiar with some of the various keyboard shortcuts associated with it. We’ll list off some of the most commonly used keyboard shortcuts, as well as what you can do to become a Microsoft Excel power user.

Before we get started, keep in mind that most keyboard shortcuts that work with Microsoft Word and other products in the Office suite will also work in Excel. We’re talking about the good old staples of Copy, Cut, Paste, Find, and so much more. Be sure to try out some of your favorites to see if they work in Excel, too.

Check Formulas in Cells
Excel doesn’t show you your formulas in the cells--it instead shows the results of the formulas. While you can click on the cell and view the formula bar at the top of the spreadsheet to see how the results are showing up, this can take some time if you’re checking an entire row or column. To toggle between a spreadsheet containing your values and your formulas, you can use the Ctrl + ` keyboard shortcut.

Place Borders Around Cells
If you’re not too concerned with the specific border you want for your cells, just use the keyboard shortcut Ctrl + Shift + 7. This will surround the selected cells with a nice, simple border that’s very minimalist, but gets the job done.

Remove Borders from Cells
There’s a keyboard shortcut to remove borders from cells, too. It’s as easy as pressing Ctrl + Shift + - (minus). It’s the perfect solution to a botched border job.

Select an Entire Row or Column
You can select the contents of an entire row by clicking on the first cell in the row and hitting Shift+Spacebar. On the other hand, you can do the same for a column by pressing Ctrl+Spacebar.

Format an Object or Chart
Let’s say you want to insert a picture or a chart into an Excel spreadsheet, but you don’t know how to format it. You can use the keyboard shortcut Ctrl+1 to bring up the proper formatting dialogue box.

Do you have a favorite Microsoft Excel shortcut? Leave it for us in the comments, and be sure to subscribe to our blog.

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, 19 January 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

Security Tip of the Week Best Practices Technology Cloud Hackers Privacy Malware Email Business Internet Microsoft Hosted Solutions Computer Business Computing Windows 10 IT Services Android Backup Software Smartphone Ransomware Small Business User Tips Productivity Network Security Windows Hardware Google Data Management Mobile Devices Data Browser Phishing App Facebook Office 365 Upgrade Saving Money Smartphones Gmail Business Continuity Internet of Things Managed Service Provider Outsourced IT Word Encryption Tip of the week Managed IT Services Efficiency Remote Monitoring Workplace Tips Office Tips Cloud Computing IT Support Artificial Intelligence Microsoft Office Data Recovery Big Data Miscellaneous Social Media Apple Firewall Settings Windows 10 Customer Service Content Filtering Two-factor Authentication Robot Risk Management Server IT Support Innovation Productivity Employer-Employee Relationship Data storage WiFi Cybersecurity Money Government Disaster Recovery Spam Administration Automation VoIP IBM Password Wireless Mouse Apps Mobile Device Customer Relationship Management Network Wi-Fi Hacking Hosted Solution Scam Passwords Presentation Tablet Vulnerability Hacker Avoiding Downtime YouTube communications Office Wireless Technology Holiday Business Management Recovery Printing Virtual Private Network Computing End of Support Google Drive Managed IT Services LiFi IT Management Telephone Systems Save Money Maintenance Chrome Analytics Data Backup Safety SaaS Bandwidth Outlook Antivirus The Internet of Things Search Unified Threat Management Monitors Business Technology Data loss Budget Users sip BYOD Bring Your Own Device SharePoint Network Management Managed IT Fraud Infrastructure Buisness Managed IT Service IT solutions Lenovo Digital telephony Best Practice Communication Downloads Computer Care Touchscreen Shortcut Mobile Security Disaster User Vendor Management Break Fix Cortana Superfish Spyware Storage Business Growth Writing Multi-Factor Security Training Competition Patch Management Hotspot Automobile Uninterrupted Power Supply Current Events Downtime Dark Web 5G Legal Dark Data Alt Codes Retail Cybercrime Google Calendar Language Solid State Drive Going Green Net Neutrality Marketing Knowledge Networking How To IT service Typing Social Engineering Legislation Heating/Cooling VPN Computing Infrastructure IP Address Hard Disk Drive FCC Unified Communications Experience Data Security Firefox Operating System Website Politics BDR Cryptocurrency Running Cable Comparison Servers Alerts Mobile Office Collaboration Virtual Desktop Title II Techology Hard Drives Google Maps Bitcoin How To Laptop Specifications Server Management Online Mail Merge Mobile Device Management File Sharing Information Technology Network Congestion Unified Threat Management Refrigeration Google Docs Samsung Statistics Public Speaking Websites Windows 8 Halloween Black Friday Microsoft Excel Address Lithium-ion battery Google Wallet Virtual Reality Computers User Error Augmented Reality Quick Tips Bluetooth Scary Stories Cyber Monday Blockchain Corporate Profile Drones Display Printer Fun VoIP Undo Social Sports Smart Technology Education Permissions WannaCry Application Gadgets Humor Deep Learning Access Control Time Management Virtualization Digital Payment Cabling Hacks Distributed Denial of Service Meetings Chromebook Cleaning Private Cloud Mobile Data Webcam Emoji Work/Life Balance Error Mobile Computing Point of Sale Black Market Law Enforcement Physical Security Paperless Office CrashOverride Twitter Gadget Staffing Administrator Personal Information Web Server Remote Computing GPS Computer Repair Cameras Processors Tracking Health CCTV Alert Domains Tech Support Document Management Licensing Electronic Medical Records Identity Theft Travel G Suite Notifications Supercomputer Botnet Upgrades Motion Sickness Crowdsourcing Taxes IT Budget Machine Learning 3D Printing Emergency Update IT Consultant Relocation Unsupported Software