Thank you for submitting your question. Keep reading Forbes Advisor for the chance to see the answer to your question in one of our upcoming stories. Our editors also may be in touch with follow-up ...
You can go crazy with this and actually paste in data that crosses multiple cells. To do this, after you copy it, select a bunch of tabs using CTRL, then pick Fill (on the File tab at top) > Across ...