Contact us today!
(800) 588-4430

Telesys Voice and Data Blog

Telesys Voice and Data has been serving the Fort Worth 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.

Comments

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

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...
QR-Code