Auto Complete / Auto Fill Function Result Prediction
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!