Forum Discussion
Solved
Can not enable autofill
Hi, I can not use the AUTOFILL option on my personal laptop. I have tried following options: - Enable fill handle and cell drag and drop - Enable Auto Complete for cell values - AND enable al...
Lulu_5137 Not sure why auto-fill doesn't work on your computer. But since you tag your post with Office365, try using this:
=SEQUENCE(1000,,0) this will instantly create a sequence of 1000 numbers (in rows) starting from 0. No dragging needed. Copy / Paste Values is want to keep the values and not the dynamic array.
Lulu_5137 Not sure why auto-fill doesn't work on your computer. But since you tag your post with Office365, try using this:
=SEQUENCE(1000,,0) this will instantly create a sequence of 1000 numbers (in rows) starting from 0. No dragging needed. Copy / Paste Values is want to keep the values and not the dynamic array.
