Bredy Network Management Corporation Blogs

2 minutes reading time (375 words)

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

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