When using the datafilter in excel 2007 and changes that I make to the data,
the same changes are being made to the hidden cells. For example if I try to
delete the visable rows it deletes all of the rows. If I try to use the fill
down command it applies that formula to every cell in that column. Any and
all help is appreciated.