Skip to main content

Google Sheets missing full Autofill; Text Mechanic to the rescue!

Let’s say you need a long series of numbers in your spreadsheet and you are trapped on a Chromebook. Yes, I could drag down to fill but this takes way too long if you have a long list of numbers.

I hate that Google Sheets cannot do what Excel can do below:

Excel wins at Autofill
Excel wins at Autofill

Fortunately, there is Text Mechanic– a website that provides a collection of text manipulation tools that work in your browser. I used the Generate List of Sequential Numbers tool get the series of numbers I needed.

Use Text Mechanic to Generate List of Sequential Numbers
Use Text Mechanic to Generate List of Sequential Numbers

From here, I can copy and paste my list into Google Sheets and start calculating.

Text Mechanic has some other great tools too. Take a look at Find and Replace Text and Add/Remove Line Breaks. They have been a big help.