View Single Post
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

There's no easier way.

Show the Custom View that you want to modify.
Make the changes
Choose ViewCustom Views, and click Add
Type the name of the existing Custom View, click OK
Click Yes to replace the existing Custom View.

Ben wrote:
I have a finance spreadsheet I created for myself to plan my household
budget where I have a row for every day of the year. Sine some days
nothing happens amongst the days I am planing for I created 2 views. One
which displays all the rows and a "part view" which hides the rows with
no activity. As the year goes on and I plan further down the sheet I'll
want to edit the "part view" so that it includes further rows which will
be hidden. How do I do this? When I go to View/Custom View it only
gives me the option to Show, Close, Add or Delete a view? Would I have
to delete the view, make the modifications and read it - is there any
easier way?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html