Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have begun using Named Ranges with a vengance, but as I manage them now I
see many named ranges that I did not create (looking in Name Manager). Where do the following come from? Can I delete them? ..PrintTitles ..wvu.cols ..wvuPrint.Area FIlterDatabase |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel along with a number of third party addins have leveraged named ranges
to keep track of sheet specific settings. For example print titles is how XL stores the range of Rows to repeat at the top of the page when you print. You can delete these but if you do then you will lose the settings associated with those named ranges. One interesting thing to note is that you can manipuate things like the print area and such just by chaning the value of the named range. -- HTH... Jim Thomlinson "KIM W" wrote: I have begun using Named Ranges with a vengance, but as I manage them now I see many named ranges that I did not create (looking in Name Manager). Where do the following come from? Can I delete them? .PrintTitles .wvu.cols .wvuPrint.Area FIlterDatabase |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
In Excel, show 0.00 for "zero" entries, but "-" if no entries | Excel Discussion (Misc queries) | |||
is there a software "Excel Project Manager" for construction? | Excel Discussion (Misc queries) | |||
Is "report manager" available for MS office excel 2003? | Excel Discussion (Misc queries) |