Naming Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I try to name a range of cells, the sheet name is automatically included. Is it possible to exclude the sheet name so that the same cell range can have the same name on every sheet in the same workbook
Turning on the option to include labels in formulas mostly solved the problem but occasionally there are number typos that don't get fixed right away
Grouping sheets and selecting the range work okay as well, but I'm more comfortable with names

tj
 
You can create a named range by doing insert=>Name=>Define

Name: List

Refers to: =!$A$10:$A$20


However the name will refer to the sheet where it is used I believe - it
won't create a 3D reference like Sheet1:Sheet20!$A$10:$A$20

--

Regards,
Tom Ogilvy


tjtjjtjt said:
When I try to name a range of cells, the sheet name is automatically
Click to expand...
included. Is it possible to exclude the sheet name so that the same cell
range can have the same name on every sheet in the same workbook?
Turning on the option to include labels in formulas mostly solved the
Click to expand...
problem but occasionally there are number typos that don't get fixed right
away.
 
Be aware that when you use this method, the cells referenced with such a
formula do not auto-calculate.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top