I haven't run across this one before, so not sure how to approach it. Cell A5 is a formula. I want the value of A5 to be placed in H1, but as an insert, because I want the current H1 (and H2, etc) to shift down.
As I was typing this I realized I could do the reverse: Shift the cells down, then put the value of A5 into the freshly cleared H1. But, I'd still like to know if there's a more straightforward way to do it.
Bookmarks