Contact us today!
(800) 588-4430

Telesys Voice and Data Blog

Telesys Voice and Data has been serving the Richland Hills area since 1994, 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 yet
Already Registered? Login Here
Saturday, 20 October 2018
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Blog Archive

Free Consultation

Sign up today for a
FREE Network Consultation

How secure is your IT infrastructure?
Let us evaluate it for free!

Sign up Now!

Free Consultation

Tag Cloud

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

Top Blog

Don't be Afraid to Replace Got an older PC that's causing you a lot of issues? Older technology is typically more expensive to run, and after a while, it's cheaper to simply buy a new desktop than it is to continue pouring money into something that always seems broken. It's a great time to buy wo...