New
#1
Define names in workbook scope
Hello guys,
I use MS Excel 2010. In this app, I know that using Formulas > Define names > define name it is possible to name a cell (or range). At that dialog box there is a scope rectangle which if I choose the entire sheets scope (workbook) so it's said that this name is valid for the entire workbook. First what does this valid mean please? Then, OK, I think I understand it but why when I name cell A1 (in the worksheet1 for example) to "first" its name on that worksheet is valid, that is its name, here "first", is shown in Name Box, but although I've used workbook scope, when I change the worksheet (to worksheet2) and active cell A1, just A1 is shown there not the put name, "first"!?