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 below, 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 below 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.
1 Answer
- Hit CTRL+` to "Show Formulas"
- Select and copy CTRL+C all the formulae
- Open notepad and paste CTRL+V
- Go back to Excel and press Esc
- Go back to Notepad, select all and copy CTRL+A & CTRL+C
- Go back to Excel and paste CTRL+V
- Hit CTRL+` to disable "Show Formulas"
answered Oct 30, 2022 at 23:08
F4on multiple cell references selected within one formula while in edit mode - not when you are selecting multiple cells. Its actually surprising that this doesn't work, or that Excel doesn't have a "keep references as is" paste special option on the paste menu.