Hi

I have just upgraded to Excel 2007. Here is the trouble:

I have a filtered table (hence hidden rows), and I need to input data in a fresh column.

Here is what I use to do:
- Input in the first cell of the fresh column
- Highlight the cells below it that require the data
- Use the 'fill down' (CTRL - D)

In Excel 2007, it fills up the hidden rows as well (not what I want). Now I have to use "Go to" -> "Visible Cells only" to get what I want.

Is there a way to default Excel 2007 to always fill visible cells only?