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