• Contact Us
  • Login
Upgrade
Tech News Hero
Advertisement
  • Home
  • News
  • Gadgets
  • Social
  • Gaming
  • Mobile
  • PC
  • Internet
  • Security
  • Apps
No Result
View All Result
  • Home
  • News
  • Gadgets
  • Social
  • Gaming
  • Mobile
  • PC
  • Internet
  • Security
  • Apps
No Result
View All Result
Tech News Hero
No Result
View All Result
Home Internet

Google Sheets Gets Smart Fill Feature, Helps Autocomplete Data Entry

by technewshero
December 13, 2020
in Internet
0
Google Sheets Gets Smart Fill Feature, Helps Autocomplete Data Entry
Share on FacebookShare on Twitter

Google has brought a Smart Fill feature to Google Sheets, letting the spreadsheet app detect and learn patterns between columns in order to autocomplete data entry. The tech giant said that Smart Fill will make data entry quicker and less prone to error. The feature can be used for tasks like extracting the first name of a person and finding values in a table. Smart Fill will be on by default for users. The feature has started rolling out for those on the Rapid Release schedule; other users will get the feature from November 5 onwards.

Announcing the new feature in a blog post, Google said that Smart Fill will make data entry on Google Sheets quicker, similar to how Smart Compose helps users write faster with fewer mistakes. If you have a column of full names, you may want to split it into a column with the first names and another with the last names. Smart Fill will automatically look for patterns and will generate the corresponding formula, going on to autocomplete the rest of the column.

Besides using data that’s in a sheet, Smart Fill will also use data from Google’s Knowledge Graph. It can, for example, use public data to autocomplete a list of countries where a list of cities is located.

Smart Fill can also use information from your company’s people directory to autocomplete data. For example, it can use organisation-only data to fill in email addresses for company employees. This feature, however, will be limited to Enterprise Plus customers.

The main Smart Fill features will be available for all business, education, enterprise, non-profit, and personal Google Account users. Smart Fill integration with people directory is available only for Enterprise Plus customers.

Google also launched Sheets Smart Cleanup recently, which uses similar intelligence to help prepare and analyse data in Sheets.

How to use Smart Fill

Smart Fill will be on by default. To use the feature, open a spreadsheet in Google Sheets and enter data. To use Smart Fill, Mac users should press ⌘ + Shift + Y. Windows/Chromebook users should press Ctrl + Shift + Y. Click a cell to see the formula used. Users should note that the extended rollout of the feature will take a few more weeks.

If you want to turn off the Smart Fill feature, follow these steps: Open a spreadsheet in Google Sheets. Click on Tools > deselect Enable autocomplete.


Flipkart, Amazon have excellent iPhone 11, Galaxy S20+ sale offers, but will they have enough stock? We discussed this on Orbital, our weekly technology podcast, which you can subscribe to via Apple Podcasts, Google Podcasts, or RSS, download the episode, or just hit the play button below.

Previous Post

Mario Kart Live: Home Circuit review

Next Post

Twitter’s ‘Hacked Materials’ Rule Tries to Thread an Impossible Needle

technewshero

technewshero

Related Posts

Google to Host ‘Hello 2021 India’ Virtual New Year’s Eve Party on YouTube, Launches Party Popper Icon on Search
Internet

Google to Host ‘Hello 2021 India’ Virtual New Year’s Eve Party on YouTube, Launches Party Popper Icon on Search

by technewshero
January 13, 2021
Google Is Testing a Feature That Will Aggregate Short-Form Videos From TikTok, Instagram: Report
Internet

Google Is Testing a Feature That Will Aggregate Short-Form Videos From TikTok, Instagram: Report

by technewshero
January 14, 2021
Android’s Smart Text Selection Tool Adds Unit Conversion Feature, Redirects to Google
Internet

Android’s Smart Text Selection Tool Adds Unit Conversion Feature, Redirects to Google

by technewshero
January 15, 2021
Bitcoin Jumps to Record $28,600 as 2020 Rally Reaches New Heights
Internet

Bitcoin Jumps to Record $28,600 as 2020 Rally Reaches New Heights

by technewshero
January 16, 2021
Apple Supplier Wistron Could Not Manage Scaled Up iPhone Plant, Broke Several Laws: Government Report
Internet

Apple Supplier Wistron Could Not Manage Scaled Up iPhone Plant, Broke Several Laws: Government Report

by technewshero
December 21, 2020
Next Post
The GOP Keeps Proving There’s No Election Fraud

Twitter's 'Hacked Materials' Rule Tries to Thread an Impossible Needle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Popular

Unity Software has strong opening, gaining 31% after pricing above its raised range – TechNewHero

Unity Software has strong opening, gaining 31% after pricing above its raised range – TechNewHero

December 14, 2020

UK made illegal copies and mismanaged Schengen travelers database

July 27, 2019

How to watch His Dark Materials online: stream the new show from anywhere and for free

November 3, 2019

Browse by Category

  • Apps
  • Gadgets
  • Gaming
  • Internet
  • Mobile
  • News
  • PC & Laptops
  • Security
  • Social
Tech News Hero

© 2020 Tech News Hero.

No Result
View All Result
  • Home
  • Landing Page
  • Buy JNews
  • Support Forum
  • Contact Us

© 2020 Tech News Hero.

Welcome Back!

Login to your account below

Forgotten Password?

Create New Account!

Fill the forms bellow to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In
Are you sure want to unlock this post?
Unlock left : 0
Are you sure want to cancel subscription?