Results 1 to 7 of 7

Thread: Selecting Cells

  1. #1
    Seeker John Davis's Avatar
    Join Date
    Sep 2011
    Location
    Florida
    Posts
    8
    Articles
    0

    Selecting Cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    How can I select 3 contiguous cells (A1:A3) then not select the next 15 cells (A4:A15) then select the next 3 cells and so forth for about 6,000 lines. Then delete the content from those cells.

    But please show me how to modify this so I can delete for example the content for cells (D419) but not delete contents in (D2021). Then repeat that.

    Thanks in advance!

  2. #2
    Put tmp in B1.

    In B2 add this formula

    =ISNUMBER(MATCH(MOD(ROW(),19),{1,2,3},0))

    copy down as far as you want, then filter column B for FALSE and clear column A.

  3. #3
    Seeker John Davis's Avatar
    Join Date
    Sep 2011
    Location
    Florida
    Posts
    8
    Articles
    0
    How can I delete the conents of the "true" cells but not get rid of the cells themselves? I need to retain the empty cells.

  4. #4
    Just hit the delete key when they are selected.

  5. #5
    Seeker John Davis's Avatar
    Join Date
    Sep 2011
    Location
    Florida
    Posts
    8
    Articles
    0
    When I filter by False in the B column, it automatically deletes the cells. How can I get it to just highlight the cells?

  6. #6
    No, it just hides them. Look at the row numbers.

  7. #7
    Seeker John Davis's Avatar
    Join Date
    Sep 2011
    Location
    Florida
    Posts
    8
    Articles
    0
    Ah Ha! Figured it out, thank you for your help.

Posting Permissions

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