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.

How Does Your IT Stack Up to These Standards?
Net Neutrality Still Needs Your Help!
 

Comments

Already Registered? Login Here
No comments made yet. Be the first to submit a comment

Mobile? Grab this Article!

Qr Code

Tag Cloud

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