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
Monday, 23 April 2018

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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