Fill Down Visible Rows Only in Excel

  1. Filter the data
  2. Select the cells in a Column you want to fill data
  3. F5
  4. Click Special
  5. Click Visible Only
  6. Hit Space Bar
  7. Enter the Value to Fill Down
  8. Type CTRL-ENTER

Leave a Reply

Your email address will not be published. Required fields are marked *