Auto Complete / Auto Fill Function Result Prediction

Suggestions Spreadsheet editor
,
1

Imported from UserVoice

Author: Kauê Fakri

Hello!

I use the autofill / auto complete function a lot in my Sheets to make forecasts or extend tables. It would be great to be able to see the preview of the value that the system is autofilling, so that i can know when to stop (or not).

Simple example:

I want to make a 2 year calendar header table by auto filling the months. I type JAN and FEB in the first 2 cells and use the auto complete function. So far, I don’t know which month is being filled in the cell and I simply don’t know when I’ll get Dec or Oct or any month.

The same applies to numeric sequences like 5,00 (cell A), 10,00 (cell B). By which cell I’ll get 75,00? I don´t know so far.

It helps SO MUCH.

Thanks!

3

Hello! Thanks for the suggestion — it’s been accepted as an enhancement (track number — 48328). We’ll update the thread once it’s available.