2007 Assigning Range Names in one spreadsheet/worksheet

B

bretsharon

I know how to assign range names in 2003, but can't find it in 2007. Help
only wants to talk about range names in another workbook
 
J

Jim Rech

I think you might have been mislead by the "scope" dropdown in the New Name
dialog. Unless you want to have a new name be visible only on a specific
sheet you can just ignore it, leaving it as "workbook". Just enter the name
at the top and the Refers To at the bottom.
 
B

bretsharon

Say what? ...Using your words though I cam across the dialog box and read
the help file so I got what I needed. thank you.
 
Top