![]() |
2007 Name Manager "automatic" entries?
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 |
2007 Name Manager "automatic" entries?
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 |
All times are GMT +1. The time now is 03:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com