Hi Stefi,

Yes, there is a simple way to fill down through only the visible subtotal rows in Excel 2007. Here are the steps:

1. Select the cell with the formula you want to fill down.
2. Press Ctrl + G to open the Go To dialog box.
3. Click on the Special button in the bottom left corner of the dialog box.
4. Select the Visible cells only option and click OK.
5. Excel will now select only the visible cells in the range.
6. Press Ctrl + D to fill down the formula in the selected cells.

This will fill down the formula through only the visible subtotal rows, without affecting any hidden rows.