Hi There,
I have recently started using Excel 2007 but am having some issues with short cuts from 2003.

I use to be be able to filter on data, highlight and then use the CTRL+Enter to add the same data to highlighted cells. This function would not enter data in the cells that were not filtered.

Now in 2007, when I do this, excel pastes the data to all cells including those that were hidden.

Does anyone know a shortcut to do this? I would like to enter the same data into multiple cells when filter is on.



Thanks heaps

Vince