Forum Discussion
Paste>formulas pastes values if no formula exists
I have a spreadsheet with 8 columns for each month of the year, so 96 columns total with about 350 rows going down. In each set of 8 columns (representing one month) there are 3 data entries and 5 f...
I recommend using "structured tables" in this situation because when you insert new rows, Excel will automatically copy all the formula but leave the constant values blank. They take a little learning but they are definitely worth it.
The other, old fashioned way of doing this is to paste the block of formula, then
- select the whole target range
- use F5 to "go to" the constants only
- press delete, leaving only the formula
Hopefully i understood your query properly.
Thanks so much! Using the f5 method will work fine for now until I have time to learn structured tables. Will save me much time and frustration!