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.

Comments

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

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