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

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