I have a worksheet of about 700000 entries, with 3 columns, I need to fill the last column C with 0 for all of them, what is the best way to do it.
I have a worksheet of about 700000 entries, with 3 columns, I need to fill the last column C with 0 for all of them, what is the best way to do it.
Last edited by hendrikbez; 08-05-2019 at 05:04 AM.
If columns A and B already have data all the way down the the 700000th entry, you should be able to type 0 in C1, then hover over the bottom right corner of C1 until the cursor turns into a black "+" sign - then double click the corner. The 0's should fill all the way down.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks