I
I
Ivan Pavlov2018-09-16 11:09:16
Google Sheets
Ivan Pavlov, 2018-09-16 11:09:16

How to copy one line n times?

I have a file with 80 thousand lines, I need to add a new column and specify the same value in each line in it. Just copying it down takes a lot of time, how can it be done in one or two steps?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
B
Bcoon, 2018-09-16
@Volunteer

Double-click on the autocomplete marker (the square in the lower right corner of the active cell) - and everything will "stretch" down by itself

D
Dresh, 2018-09-16
@Dresh

You need to click on a column --> copy, then click on another column --> paste

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question