+ Reply to Thread
Results 1 to 2 of 2

Fill column

  1. #1
    Forum Contributor
    Join Date
    09-03-2008
    Location
    Johannesburg, South Africa
    MS-Off Ver
    2021
    Posts
    311

    Fill column

    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.

  2. #2
    Registered User
    Join Date
    08-15-2019
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel for Mac 16.27
    Posts
    3

    Re: Fill column

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 04-09-2019, 03:29 PM
  2. Replies: 8
    Last Post: 07-04-2018, 10:03 AM
  3. [SOLVED] fill column and no fill column macro
    By Alastair77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2014, 12:23 PM
  4. Insert column and fill column upto where data is in previous column
    By aka189 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-24-2012, 06:07 AM
  5. [SOLVED] If column A has gray fill and column B has no fill, delete that row
    By killhuman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2012, 05:36 PM
  6. Replies: 0
    Last Post: 08-10-2012, 12:55 PM
  7. Replies: 1
    Last Post: 09-07-2011, 05:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1