The cells I selected in Screenshot are relatively the same. What I want to do now, is reuse that upper table by copying the lower table beneath, but don’t change values. I was thinking if I could at the same time selected cells turn to absolute by pressing F4
, I could easily copy them beneath without changing anything if I could apply F4
for all selected cells. I found that it should work by pressing F4
while selected multiple cells here, but for me Excel says "We couldn't find what you are looking for"
. How can I achieve this? Thanks.