I created A LOT of names of cells in an Excel worksheet using the Name Box (to the left of the Formula Bar). Then, I decided to make a different version of the worksheet in the same workbook. And then another version and so on.
When I check the Name Manager window, I see a mix of workbook- and worksheet-scoped name.
Just in case, I would like to convert workbook-scoped to worksheet-scoped names. Is there an easy way to do that?