Voyage Tech Blogs

Voyage Technology has been serving the Beaver Dam area since 1999, 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, 18 February 2025

Captcha Image

Sign Up For Our Newsletter!

Mobile? Grab this Article!

Qr Code

Tag Cloud

Security Technology Tip of the Week Best Practices Business Computing Data Productivity Business Software Innovation Hackers Cloud Network Security User Tips Hardware Internet Efficiency IT Support Malware Privacy Email Phishing Google Workplace Tips Computer Users Collaboration IT Services Hosted Solutions Mobile Device Quick Tips Ransomware Cybersecurity Workplace Strategy Small Business Microsoft Communication Data Backup Smartphone Passwords Saving Money Business Management Android Smartphones VoIP communications Mobile Devices Backup Managed Service Data Recovery Upgrade Browser Managed IT Services Social Media Disaster Recovery Microsoft Office Tech Term Network Remote Windows Internet of Things Facebook Automation Artificial Intelligence Cloud Computing Covid-19 Remote Work Miscellaneous Gadgets Productivity Server Managed Service Provider Current Events Information Holiday Outsourced IT AI Employee/Employer Relationship Spam Encryption Windows 10 Government Data Management Training Office Business Continuity Compliance Wi-Fi Virtualization Business Technology Bandwidth Blockchain Windows 10 Two-factor Authentication Apps Mobile Office Data Security Gmail Vendor Employer-Employee Relationship Chrome Managed Services Voice over Internet Protocol Budget Apple Networking Mobile Device Management App BYOD Computing WiFi Applications Information Technology Access Control Office 365 Tip of the week Conferencing Hacker Avoiding Downtime Marketing How To BDR Operating System HIPAA Router Big Data Virtual Private Network Risk Management Health Help Desk Analytics Office Tips Augmented Reality Computers Retail Storage Password Healthcare Bring Your Own Device Website Managed IT Services Remote Monitoring Vulnerability End of Support Vendor Management Solutions Cybercrime The Internet of Things Display Windows 11 Social Printer 2FA Paperless Office Infrastructure Monitoring Excel IT Support Customer Service Document Management Remote Workers Telephone Scam Data loss Cooperation Free Resource Project Management Windows 7 Going Green Patch Management Firewall Save Money Microsoft 365 Settings Printing Wireless Content Filtering Safety IT Management VPN Employees YouTube Meetings Physical Security Integration Cryptocurrency User Tip Modem Computer Repair Mobile Security Processor Virtual Desktop Holidays Supply Chain LiFi Data storage Data Storage Smart Technology Customer Relationship Management Video Conferencing Outlook Machine Learning Managed Services Provider Professional Services Money Saving Time Virtual Machines Hacking Humor Presentation Managed IT Service Maintenance Wireless Technology Antivirus Sports Downloads iPhone Mouse Licensing Data Privacy Vulnerabilities Entertainment Administration Word Images 101 Telephone System Multi-Factor Authentication Robot Mobility Cost Management Workforce Alt Codes Content Remote Working Entrepreneur Wearable Technology Memory Threats Health IT Downtime Unified Threat Management Motherboard Data Breach Comparison Google Play Hosted Solution Assessment Electronic Health Records Permissions Unified Threat Management Directions Videos Workplace Strategies Undo Meta Typing Wasting Time Network Congestion Specifications Security Cameras Amazon Trend Micro Internet Exlporer Software as a Service Knowledge Fraud Google Drive User Error Microchip Outsource IT Username Managing Costs 5G Black Friday SSID Environment Media Point of Sale eCommerce Application Unified Communications Database Surveillance Experience Virtual Assistant Google Docs Small Businesses Bitcoin Network Management Running Cable Tech Support IT Technicians Virtual Machine Monitors Cyber Monday Medical IT IBM Displays Google Wallet Proxy Server Reviews Cookies Tactics Development Hotspot Transportation Outsourcing Windows 8 Laptop Websites Mirgation Hypervisor PowerPoint Drones Shopping Nanotechnology Optimization Workplace Addiction Electronic Medical Records Language Employer/Employee Relationships SharePoint Competition Hiring/Firing Management PCI DSS Halloween Chatbots Navigation Writing Distributed Denial of Service Lenovo Gig Economy Paperless Screen Reader Co-managed IT Service Level Agreement Internet Service Provider Virtual Reality Computing Infrastructure Teamwork Technology Care Hacks Server Management Regulations Compliance Scary Stories Private Cloud Identity Evernote Fun Superfish Bookmark User Business Communications Identity Theft Smart Tech Memes Scams Deep Learning Download Net Neutrality Twitter Alerts SQL Server Hybrid Work Financial Data Error History Social Engineering Break Fix IP Address Browsers Smartwatch Human Resources Education Connectivity IT Cables Upload Procurement Remote Computing Azure Mobile Computing Social Network Telework Cyber security Multi-Factor Security Tech Search Dark Web CES Recovery Google Apps Tablet IoT Communitications Hard Drives IT Maintenance Best Practice Trends Supply Chain Management Alert Domains Business Intelligence Managed IT Customer Resource management FinTech Buisness File Sharing Regulations Dark Data Google Calendar Term How To Microsoft Excel Legal Data Analysis Shortcuts IT solutions Star Wars IT Assessment Refrigeration Ransmoware Business Growth Gamification Flexibility Notifications Staff Value Public Speaking Vendors Organization Travel Social Networking Legislation Cortana Lithium-ion battery Techology Fileless Malware Digital Security Cameras Be Proactive Google Maps Smart Devices

Blog Archive