4IT Blog

4IT has been serving the Miami area since 2003, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: 3 Better Ways To Use Excel

Tip of the Week: 3 Better Ways To Use Excel

Microsoft Excel is more or less synonymous with spreadsheet creation. However, even power users may not know all the tricks that are hidden in the program that can help them save significant time. For this week’s tip, we’ll go over some Excel shortcuts that you may not have known about.

Adding the Same Text to Multiple Cells
It’s a hassle that every Excel user has faced: the same text needs to be inserted into many cells. Fortunately, there’s a simpler way to go about doing this than one cell at a time. If you highlight the cells that need the text entered before typing the text, and press Ctrl and Enter instead of just Enter, your selected cells will have that text added in.

Auto-Sum Shortcut
Excel can naturally be used as a quick-adding calculator, but a quick shortcut can make that easier. Highlighting the cells, you need to add together before pressing Alt and = will give you final sum.

Data Sorting, Made Easier
In those cases where you need your data to be sorted by a particular variable, Microsoft gives you the means to do so in their Auto Filter. Once your spreadsheet is populated with your data, you can select the columns to be filtered by selecting the top rows. Once you’ve done so, click Data. You will then see options for Filter and subsequently, Auto Filter. This adds a drop-down menu to each column, allowing you to sort the entire spreadsheet by that data in that column.

What are your most-used Excel shortcuts? Tell us in the comments, and check back in to the 4IT blog for more useful tips.

 

Comments 1

pragya abi on Friday, 11 August 2017 09:05

on the off chance that you need to shake an Excel like an electric guitar, you must do your finger picking with the console. For example, holding down control while tapping a bolt catch will choose each cell the distance to the finish of the sheet. Flip through worksheets by holding control while squeezing either page down or page up.

custom paper writing services

on the off chance that you need to shake an Excel like an electric guitar, you must do your finger picking with the console. For example, holding down control while tapping a bolt catch will choose each cell the distance to the finish of the sheet. Flip through worksheets by holding control while squeezing either page down or page up. custom paper writing services
Already Registered? Login Here
Guest
Monday, 21 August 2017
If you'd like to register, please fill in the username, password and name fields.

Mobile? Grab this Article!

Qr Code

Tag Cloud

security Tip of the Week Technology Cloud Best Practices Privacy Microsoft Internet Business Computing software Hackers Backup Hosted Solutions Productivity Business Management Managed Service Provider Malware IT Services Business Efficiency Google Windows Innovation IT Support Hardware Disaster Recovery Workplace Tips Saving Money Computer Windows 10 Miscellaneous VoIP Business Continuity Virtualization Upgrade User Tips Mobile Devices Data Server Mobile Device Management Mobile Computing Email Network Network Security Save Money Communication Alert Quick Tips Information Technology Social Media Smartphones Microsoft Office BYOD communications Going Green Mobile Office Apps Small Business Smartphone Health Office Browser Outsourced IT Gadgets Operating System Android Application Ransomware Managed IT Services Firewall Avoiding Downtime Disaster Tablet Productivity WiFi Search Managed IT Holiday Chrome The Internet of Things Passwords Remote Computing Mobility Unified Threat Management IT Solutions Spam Risk Management BDR Remote Monitoring Automation History Hacking Best Practice Data Management Facebook Vendor Management Hard Drives Employer-Employee Relationship Saving Time Telephone Systems Budget Recovery Phone System Customer Relationship Management Office Tips Cybersecurity VPN Apple Wireless Technology Phishing Password Marketing Big Data Cybercrime Hosted Solution Computers Wearable Technology iPhone User Error Maintenance PowerPoint Lithium-ion battery Collaboration Virus Law Enforcement Antivirus Current Events Social Bring Your Own Device Printer USB Content Filtering Telephony Analytics Money Gmail Router Humor Administration Proactive IT Cloud Computing Google Drive Cost Management Save Time Intranet Bandwidth Printer Server Users Laptop OneNote HaaS Windows 8 Work/Life Balance Trending Education Net Neutrality Shortcut Business Intelligence Office 365 Tech Support Social Engineering Point of Sale Outlook IT COnsultant Encryption Computer Repair Wireless Private Cloud Unsupported Software Government App online currency Mouse Internet Exlporer Compliance Social Networking Internet of Things Identity Theft Two-factor Authentication Managing Stress Data Protection Solid State Drive SaaS Flexibility IT Support Excel Efficency Audit Samsung Update Customer Service Display Biometrics Retail Augmented Reality Data Storage Virtual Reality Network Congestion hacker Paperless Office Meetings Personal Information Help Desk Transportation Fax Server Data Backup Battery Instant Messaging Robot Emails Computer Care Workplace HIPAA Automobile Entertainment Streaming Media Benefits End of Support Computer Accessories Uninterrupted Power Supply DDoS Twitter Document Management HBO Data Breach Branding Advertising best practices Legal CrashOverride Surge Protector Distributed Denial of Service Mobile Device Television IT Management Touchpad 3D Printing Managed Security data breach WIndows 7 eWaste Settings Inbound Marketing Scam Hard Drive WIndows Server 2008 Regulations risk management Sports Value ISP Uograde Employer Employee Relationship Images Worker Commute Patch Management Operating Sysytem Cameras User PDF Windows 10 Scalability Commerce Science Files Programming Blogging Regulation Virtual Desktop Presentation Best Available Safety Bluetooth Text Messaging Vulnerability IT Technicians How To Data Recovery Chromecast Travel Website Upgrades Wi-Fi Sync Emergency Wiring SharePoint Artificial Intelligence iOS Managed IT Service Administrator OneDrive Information Training Amazon Consultant Applications Colocation Managed IT Services Debate Co-managed IT The Blindside Of Teamwork Computer Fan Black Market Access Busines Continuity Company Culture Touchscreen Politics Networking Near Field Communication IT Security Dark Web Screen Mirroring Ebay Cleaning Computing Experience Human Resources IT consulting Keyboard Running Cable Avoid Downtime Cast Nokia Music Windows 10s Reliable Computing Hiring/Firing Nanotechnology Data Security Bloatware Data storage Books Hard Disk Drive Root Cause Analysis Smart Technology Video Games Storage Taxes Microblogging Youtube IT service Gift Giving Supercomputer Sales Electronic Medical Records Domains IT Budget Managed Service Provder Webinar Reputation Adobe Buisness Webinar Lifestyle Shadow IT Relocation IT solutions Tutorial