开发者

Excel Name references to absolute sheet, how to make it relative

in workbook scope

in sheet1 I define name Test = B1, then excel automatically makes it as She开发者_如何学运维et1!B1. now when I use the name in sheet 2. I am expecting that it would refer to B1 in sheet 2 instead of Sheet1!B1. How could I do that?


You can refer to !$A$1, this will refer to the current Worksheet.

Regards,

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜