Excel is one of the most-used products in the Microsoft Office suite. It still stands tall amid the rise of online documentation tools, especially from Google, because of its reliability. Microsoft announced that it would introduce a few new features which will help you use the formulas easily. It is an attempt to improve the auto-complete feature in the web version so that the software can intelligently predict the formulas you need to use for a data set.

The Verge reported that the feature was only available on the web version as of now. Make note that when you add a bunch of numbers in a column in Google Sheets and enter an (=) sign, it automatically recommends the sum formula for all the rows in a column. This new autocomplete feature in Excel offers the same functionality.

New Excel feature details

The first one is obviously the auto-suggesting formulas after you enter an ‘equals to’ sign. But innovation doesn’t stop there. Now, Excel will try to find patterns in your existing data sheet and suggest formulas to help you fill in the sheet faster. A simple example in Microsoft’s official blog showcases that there are four columns quarters in a sheet. The fifth column is Average.

news, microsoft

Image: Microsoft

Rather than adding all the numbers manually or figuring out a formula for that, Excel will suggest a formula to fill an entire column in one go. So, you can do the same for the whole column with Excel’s new feature rather than applying the sum formula to every row.

More new features include an IMAGE function that inserts images into cells from a source location. You can even add alt text to images to give them more context and even give credit where it’s due. Users can perform searches within the queries pane, and the new suggested links feature is also rolling out shortly. Make note that these updates are only rolling out for the web version of Microsoft Excel. There are different changes and feature additions for Windows and Mac users, which you can find on Microsoft’s official blog.

TECH NEWS RELATED

9 Best Ways To Retrieve A Downloaded Movie On Your Laptop

Watching movies online can be a hassle; Especially when there is a lot of buffering. This is one of the biggest reasons for people to download their movies and watch them offline. However, I found this specific query in a forum where people were asking to recover a downloaded movie ...

View more: 9 Best Ways To Retrieve A Downloaded Movie On Your Laptop

How To Snip Screen On Your Laptop?

Taking a screenshot is not a complicated process. All of us are familiar with at least one way to do it. However, there are several ways to capture your screen for a frame. We made this article to show you all the different ways you can grab your screens. If ...

View more: How To Snip Screen On Your Laptop?

How To Connect AirPods To A Laptop?

The Apple AirPods are, undoubtedly, some of the best earpieces available on the electronics market. With three generations of different AirPods models, these sleek, ivory earphones are quite popular. Apart from the appearance and quality, AirPods are known for being versatile. Irrespective of what the host device is, AirPods can ...

View more: How To Connect AirPods To A Laptop?

7 Best Ways To Fix DistributedCOM Error In Windows

If you open the Event Viewer utility often, you may notice a DistributedCOM Error on Windows. Let’s know what this DistributedCOM Error Windows error is, how it’s caused, and how you can fix it. Contents show 1 What Is the DistributedCOM Error Windows 10 and 11? 2 What is the ...

View more: 7 Best Ways To Fix DistributedCOM Error In Windows

12 Easy Fixes For Webcam Not Working In Windows

Cameras are becoming quite common for PCs. We use meetings on Zoom, Microsoft Teams, Skype, and other options. The operating system might not be at fault if your camera isn’t working. You can use the given solutions to solve the Webcam Not Working Windows issue quickly. We have covered ...

View more: 12 Easy Fixes For Webcam Not Working In Windows

Windows 10 Sound Not Working: 18 Quick And Easy Methods

Is  Windows 10 Sound Not Working on your PC? This is a common issue faced by many Windows users.  If you are one among them, you are in the right place. This article gives you 11 solutions to fix the no-sound issues in Windows 10.  Contents show 1 Reasons For ...

View more: Windows 10 Sound Not Working: 18 Quick And Easy Methods

Fix CAA20004 Microsoft Teams Sign in Error

Microsoft Teams have a bundle of excellent and attractive features that provides you with easy communication among friends, even classes and offices were conducted online. There’s a lot going on in MS Teams, for example, you can chat via messages and video calls, and at the same time share files ...

View more: Fix CAA20004 Microsoft Teams Sign in Error

How To Fix This Update Is Not Applicable To Your Computer Error: 11 Quick Fixes

Windows standalone updates packages are useful when your Windows updater is not working or you want to install a certain update manually. However, running these updated packages, sometimes, shows the error message “This update is not applicable to your computer” or “This update is not applicable to your computer”. ...

View more: How To Fix This Update Is Not Applicable To Your Computer Error: 11 Quick Fixes

Windows Dual Boot Menu Not Showing: 6 Easy Ways To Fix

12 Best Fixes: Windows 10 Start Menu Search Not Working

How to customize and publish a Microsoft Bookings page?

Chic-Fil-A’s Training Program Apparently Features a Familiar Fallout Face

Microsoft Teams Status not updating or changing

Don’t Buy a Foldable Until Samsung Brings This Prototype to Life

Windows Encryption Not Working? 6 Best Ways To Fix

How to get Apple Calendar on Windows PC

Windows Update Error 0x80073701: 9 Best Ways To Fix

Best Ways To Fix Slow Internet During VPN On Windows 11

6 Solutions To Fix Wmpnetwk High CPU Usage In Windows

Save Time in Microsoft PowerPoint by Making Your Own Theme

OTHER TECH NEWS

Top Car News Car News