Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Names from .xls
My spreadsheet has many formulae with Names. I want to view the sheet with
the actual cell references instead of Names .. how to? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Names from .xls
Hi, I've never tried this but it says it will do exactly what you want. Check out about the info half way down (or [ctrl + F] "unapply names") on the webpage below & then download the free trial: http://www.j-walk.com/ss/pup/pup6/features.htm hth Rob Brockett NZ Alway's learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=565526 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Names from .xls
I did this for a client recently. Essentially you need to make a list of the
names and a list of the refers to and then replace each. Somewhat involved but the proper macros can do it. -- Don Guillett SalesAid Software "Bharath Rajamani" wrote in message ... My spreadsheet has many formulae with Names. I want to view the sheet with the actual cell references instead of Names .. how to? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Names from .xls
I'd do this against a copy of the file...
Jim Rech posted a nice response at: http://groups.google.com/groups?thre...%40tkmsftngp03 From: Jim Rech ) Subject: Can I "De-Name" Formula Cell References? Newsgroups: microsoft.public.excel.misc, microsoft.public.excel Date: 2001-02-16 13:32:51 PST To do it to a cell or two first turn on Transition Formula Entry under Tools, Options, Transition. Then go to the cell and press F2 and Enter. When you turn off TFE the formula references should be de-named. If you have a lot of cells to de-name select the range and run this macro: Sub Dename() Dim Cell As Range ActiveSheet.TransitionFormEntry = True For Each Cell In Selection.SpecialCells(xlFormulas) Cell.Formula = Cell.Formula Next ActiveSheet.TransitionFormEntry = False End Sub -- Jim Rech Excel MVP ==== Be aware that any reference to those names in your code will be broken. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm ====== You may want to get Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp It might make it so you want to keep the names! Bharath Rajamani wrote: My spreadsheet has many formulae with Names. I want to view the sheet with the actual cell references instead of Names .. how to? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Names from .xls
If you want a list of Range names (i.e. where a name has been defined for a
cell) Got to a blank area or open a new sheet Click on <Insert<Name<Paste<Paste List Regards. Bill Ridgeway Computer Solutions "Bharath Rajamani" wrote in message ... My spreadsheet has many formulae with Names. I want to view the sheet with the actual cell references instead of Names .. how to? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Names from .xls
or
Sub listnames() Application.Calculation = xlManual For Each n In ThisWorkbook.Names lr = Cells(Rows.Count, "a").End(xlUp).Row + 1 Cells(lr, 1) = n.Name Cells(lr, 2) = n Next Application.Calculation = xlAutomatic End Sub -- Don Guillett SalesAid Software "Bill Ridgeway" wrote in message ... If you want a list of Range names (i.e. where a name has been defined for a cell) Got to a blank area or open a new sheet Click on <Insert<Name<Paste<Paste List Regards. Bill Ridgeway Computer Solutions "Bharath Rajamani" wrote in message ... My spreadsheet has many formulae with Names. I want to view the sheet with the actual cell references instead of Names .. how to? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove the annoying automatic date formatting in Excel? | Excel Discussion (Misc queries) | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
look up names in one excel tab to find a match in another tab | Excel Discussion (Misc queries) | |||
Can't Insert of remove worksheet in an existing workbook | Excel Discussion (Misc queries) | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions |