Keeping the formula names the same but changing the format of a table in Excel 2007.?

Question

I'm trying to edit an Excel 2007 table with named formulas. These formulas have names like: OperatorName, ReadingTemp, ReadingTime, etc. They are in a pop down menu (name box) to the left of the formula bar. The names point to information on another sheet in the work book.

I want to change the look of the table but keep the same names and where they point to. But when I select an empty cell and pick a name from the drop down menu or from Formulas>Define Names> Apply Names all that happens is the selected cell changes to the cell that already has that name applied to it.

The only way I can seem to get it to work is to type in the function "=OperatorName". But when I delete the original cell that used "OperatorName" the cell goes blank. I could just use "=(where ever the info on the other work sheet is)" but I was hoping to keep the macros as they were with the drop down menu and all, and just change the format of the table.

Please help.

Answer 1

I'm a little confused - but I think you want to change the cell reference of your named ranges? If I'm right, go to the Formulas tab and click on Name Manager. The Name Manager will give you a list of your named ranges as well as the cell address/range they are applied to at the bottom of the box. By changing the cell reference here, your formulas and marcos should not be affected.

Answer 2

You can find some helpful how-to's here: http://office.microsoft.com/en-us/excel/HA102376171033.aspx?pid=CH100740791033. This help page breaks down how to create, edit, and organize tables according to your preferences.



When you're done, share your story with the Excel team. I know they'd love to hear it. http://www.facebook.com/pages/Microsoft-Excel/89421301366



Cheers,

Kim

MSFT Office Outreach Team

Answer 3

VLookup can not learn a fee to a form of values. i'm not precisely particular what your purpose is, besides the reality that it type of feels that maybe you opt to shopper-friendly distinctive numeric grades and convert that to a 'element'. if so, I advise you assign a cellular to shopper-friendly your form of numeric grades. Then in an adjacent cellular, enter a nested if function to remodel the consumer-friendly to a 'element'. in the adventure that your shopper-friendly grade is in A1, the formula in B1(or the cellular of your determination) to remodel that to a 'element' is: =If(A1>87,"element 4+",If(A1>80 3,"element 4",IF(A1>seventy 9,"element 4-","")))