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.

 

Comments

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

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