Bredy Network Management Corporation Blogs

BNMC has been serving the Andover area since 1988, 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.



No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Monday, 19 March 2018
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Subscribe to Our Blog!

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

Sign up for our Newsletter!

  • Company Name *
  • First Name *
  • Last Name *

      What Our Clients Say

      • BNMC has provided us with nothing less than outstanding service and results for all of our IT needs for the past few years. Every member of their staff is professional, knowledgeable, friendly and eager to solve any problem...
      • 1
      • 2
      • 3