Home |
Search |
Today's Posts |
#1
|
|||
|
|||
editing custom views
Hello,
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? Thanks, Ben -- "What passes for wisdom may only be eloquent foolishness" Cheap long distance calling using Onesuite (http://www.onesuite.com). 2.5 c/min within the U.S. or to Canada. 3.5 c/min to Israel. No monthly or connection fees! Use promotional code 04AQ48345 for 20 free minutes. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 custom toolbars | Excel Discussion (Misc queries) | |||
Excel2000: Custom data validation and named ranges | Excel Discussion (Misc queries) | |||
File is locked for Editing by user problem | Excel Discussion (Misc queries) | |||
How do I create a custom scroll bar on a 3D Pivot Chart? | Charts and Charting in Excel | |||
Custom Header | Excel Discussion (Misc queries) |