Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Auitofilter and copy down (Excel 2003)

    If I have a list and use the autofilter to filter data. If I put a formula in 1 of the filtered cells and use the copy down function when will it copy to all the cells down and when only the visible cells. Are there any rules. Sometimes if you copy it copies to all the cells other times only the visible cells

    TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Auitofilter and copy down (Excel 2003)

    As far as I can tell, fill down will only affect the visible cells. Could you attach a small sample workbook where filling down will affect all cells, including hidden ones?

Posting Permissions

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