Check out help on ViewCustom Views

You can create multiple views of the same worksheet and select whichever
from the list.


Gord Dibben MS Excel MVP


On Wed, 17 Feb 2010 15:14:01 -0800, Sue
wrote:

Isn't there a way I can create different views of data on a worksheet? I
know you can hide and delete columns from being displayed, but I'd like to be
able to save those criteria, such that when I open a worksheet, I can choose
which set of data I see.