| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing `named range“ from worksheet
I have an existing spreadsheet (ss) which has numerous worksheets with
named ranges on them. I'd like to REMOVE the named ranges without deleting the VALUES in the cells. The RANGES are presently linked to exterior text files. Please advise!! Also.. would like to make NEW named ranges of cells afterwards. -Gregory |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing `named range“ from worksheet
Hi Gregory,
Below is a link to an excellent Name Manager ... http://www.jkp-ads.com/officemarketplacenm-en.asp |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing `named rangeĀ“ from worksheet
I think you want to paste the values into the cell rather than the reference.
If use use ocpy then paste special (in the edit menu) you can select value. You may want to keep the old values, so I would add a new column, then hide the old column so you don't loose the refernce information. "Gregory" wrote: I have an existing spreadsheet (ss) which has numerous worksheets with named ranges on them. I'd like to REMOVE the named ranges without deleting the VALUES in the cells. The RANGES are presently linked to exterior text files. Please advise!! Also.. would like to make NEW named ranges of cells afterwards. -Gregory |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing `named range“ from worksheet
On Feb 15, 11:17 am, "Carim" wrote:
Hi Gregory, Below is a link to an excellent Name Manager ...http://www.jkp-ads.com/officemarketplacenm-en.asp Thanks.. have added it in. Also printed the 20-page doc. Will be giving it a go today. -G |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| Using Named Range with protection on the worksheet | Excel Discussion (Misc queries) | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
| toggling which worksheet a named range refers to | Excel Discussion (Misc queries) | |||
Linear Mode
