Emerald City Solutions

Stay up-to-date with the latest technology news.

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.

1. 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.

2. 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.

3. 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 Emerald City Solutions blog for more useful tips.

Worry Less With Hardware-as-a-Service
Is It A Good Idea To Bait A Phishing Scam?

Related Posts

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Thursday, 17 August 2017

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Blog Archive

Tag Cloud

Tip of the Week security email technology Best Practices Privacy IT Support malware Business Computing Business Management Software Backup User Tips hackers Cloud Hosted Solutions Internet Passwords Google phishing business Managed IT Services Ransomware Small Business Social Media Unsupported Software Microsoft Marketing Browser Productivity threats Hardware Screen Mirroring IT Services Disaster Recovery Efficiency Cloud Computing Facebook business owner App devices Outsourced IT Alert Windows Gadgets Android Smartphone Managed IT emails Computers Save Money Augmented Reality Emerald City Solutions Windows 10s search engines Data Recovery Risk Management Upgrades Audit data leak Virtualization Chrome access Hosted Solution Solid State Drive IT Management Law Enforcement Cybersecurity company ’s network Spam today ’s business world Data Storage Hard Disk Drive Social Engineering IT Solutions WiFi Computer Care CrashOverride solutions Employer-Employee Relationship Information Technology business computer system Proactive IT Wireless Computer Fan OneNote mobile business Cast Communications Computer snail mail WIndows Server 2008 consumer goods cyber threats Money Office 365 BYOD Telephone Systems Windows 10 spam cost Patch Management BDR Innovation technology research organization Touchscreen Mobile Device Management Consultant Vulnerability Outlook Nanotechnology locks users Managed Service Provider Meetings Data Security Unified Threat Management Smartphones time Shortcut Apps email protection Webinar blocks admittance Network HBO Cybercrime employees Excel Root Cause Analysis today ’s Internet IT solutions text messages Google Drive Best Practice iOS Business ’ Security Businesses Microsoft Office SaaS Application Operating System Facebook pop-ups Commerce Data Protection Business Continuity network security

Recent Comments

No comments yet.