How may I see the names of a separate Excel worksheet from within an active worksheet name-box? -
i using excel 2010
how may see names of separate worksheet within active worksheet name-box please?
regrads
the name box ever show names can use in current sheet, i.e. workbook scoped , current sheet scoped names, not names scoped other worksheets.
to see names sheet, open name manager, sort scope , scroll down worksheet name after.
name manager has filter button show workbook scoped versus worksheet scoped names, cannot filter on specific worksheet.
Comments
Post a Comment