本文介绍了Excel相关 - 第二次转发的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个worbook名称''student''它有1到60张。我选择了所有床单的B2号单元格。我想改变所有1-60张的B2单元格中的公式。 sheet1单元格B2中的公式是= [sub.xlsx] Sheet1!$ B $ 2


$ 3 $ b在sheet3中公式应该更改= [sub.xlsx] Sheet1!$ B $ 3


$ 4 $ b在sheet4单元格B2中公式应该改变= [sub.xlsx] Sheet1!$ B $ 4

在sheet5单元格B2中的公式应该改变= [sub.xlsx] Sheet1!$ B $ 5

在sheet6单元格B2中公式应该改变= [sub.xlsx] Sheet1!$ B $ 6



执行此工作簿中有多少张

就像链接单元格一样,即按=然后输入,但是它的工作量很大。



SHOUTING已删除 - OriginalGriff [/ edit]

I have a worbook name ''student'' it has 1 to 60 sheets. I have selected cell No. B2 of all sheets. i want to change formula in B2 cells of all 1-60 sheets. The formula in sheet1 cell B2 is =[sub.xlsx]Sheet1!$B$2

in sheet3 the formula should change =[sub.xlsx]Sheet1!$B$3

in sheet4 cell B2 the formula should change =[sub.xlsx]Sheet1!$B$4
in sheet5 cell B2 the formula should change =[sub.xlsx]Sheet1!$B$5
in sheet6 cell B2 the formula should change =[sub.xlsx]Sheet1!$B$6

do this how many sheets in this workbook
its like as link cells i.e press = then enter , but its a bore work.

[edit]SHOUTING removed - OriginalGriff[/edit]

推荐答案




这篇关于Excel相关 - 第二次转发的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-13 18:35