![]() ![]() If you don't want to use drag and drop or double-click to autofill numbers in Excel, you can achieve the same effect using the fill command on the Ribbon. ![]() How can I fill column A from A1 - A5000 with the same text string ABC DEF without dragging it in Google Sheets? E.g.: A1 ABC DEF A2 ABC DEF A5000 ABC DE In this article, you will learn how to autofill numbers without dragging the fill handle in Excel & Google Sheets. I sent the user a simple formula that could autofill column A given a starting number, but that's not exactly what the user is looking for. For Google Sheets, I have a user in finance who wants to have a descending number appear in column A when a new row is started. Millones de Productos que Comprar! EnvĂo Gratis en Productos Participantes Sheets auto populate a column without dragging the blue box. Home Autofill Google Sheets without dragging
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |