Enhanced Smart Fill
Enhanced Smart Fill in Google Sheets predicts and suggests values, formulas, and more to help you complete tasks faster. Gemini learns from your existing data to provide intelligent suggestions.
How can it help me?
Automating data entry: Enhanced Smart Fill automatically detects incomplete column pairs and predicts the remaining values. This helps you save time and reduces manual effort, especially when working with large datasets or repetitive tasks.
Improving data accuracy: By automating the completion of data entries, the Enhanced Smart Fill feature reduces the possibility of human error. This ensures that you have more consistent and reliable data in spreadsheets.
Streamlining data processing: The feature simplifies text processing tasks by automatically identifying patterns and completing columns, allowing you to focus on more complex analysis and insights.
How do I use it?
You can see enhanced Smart Fill suggestions in two ways:
Once an edit has been made in the file.
Live suggestions: Enhanced Smart Fill can appear while you're doing manual text entry. It appears as soon as Sheets sees it has a prediction available.
Important: The outline indicates the range Sheets can predict and you can hover over the icon to see the fill suggestions.
When you see enhanced Smart Fill suggestions, you can:
Accept the suggestion by clicking the suggestion bubble.
Reject the suggestion by clicking the cancel icon on the expanded suggestion pill to reject that suggestion for the range.
Example use cases of enhanced Smart Fill:
Categorize feedback by theme
Organize news articles by topic
Convert address data to consistent format
Extract phone numbers from text fields
Tips & Tricks
Provide enough data for the AI: Enhanced Smart Fill needs a minimum of three example rows with at least two distinct column values for it to accurately predict and fill in the remaining values. Make sure your table has enough data for the AI to learn from.
Focus on text columns: Enhanced Smart Fill only works with text. It won't be activated if you're working with numeric or date columns.
Use English: The AI behind Enhanced Smart Fill is currently trained to recognise patterns in English. Using values in other languages may not trigger the suggestions.
Watch for suggestions as you work: Enhanced Smart Fill can provide suggestions while you're typing. A dotted outline will appear around the cells the feature can predict, and you can hover over the icon to see the specific suggestions.