How to change a global named reference to a sheet named reference?

  • Thread starter Thread starter \Rob Hetlam\
  • Start date Start date
R

\Rob Hetlam\

How do I change a named reference that is visible (in the name box) on all
sheets to just a single sheet? What makes a named reference visible on all
sheets in a workbook as opposed to a single sheet?
 
when you create the name you need to use the sheet name

do Insert=>Name=>Define, select the current name and delete it. Assume the
name was profit and you want it local to sheet3

name: Sheet3!Profit

Refersto: =Sheet3!$B$2:$B$30

Now Profit will only appear in the name box when Sheet3 is the active sheet.
 
Back
Top