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