Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 52
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
how i convert "100" to "hundred"( number to text) in excel-2007 mohanraj Excel Worksheet Functions 1 May 11th 08 09:07 PM
In Excel, show 0.00 for "zero" entries, but "-" if no entries PLS Auditor Excel Discussion (Misc queries) 1 November 8th 07 04:07 PM
is there a software "Excel Project Manager" for construction? Scotty Edmonds Excel Discussion (Misc queries) 2 October 12th 06 06:24 PM
Is "report manager" available for MS office excel 2003? William Excel Discussion (Misc queries) 1 April 13th 06 12:09 AM


All times are GMT +1. The time now is 02:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"