I'm a bit embarassed to say I can't figure this out. I need to copy a formula down through a whole column, but double clicking the handle only copies down to the next header, which is a merged cell. I then need to copy and paste special in the next row under the header and repeat after every header.
This brings two questions:
1. How can I copy the formula down through the whole document?
2. How can I paste more than once without having to copy the original cell more than once?
This brings two questions:
1. How can I copy the formula down through the whole document?
2. How can I paste more than once without having to copy the original cell more than once?