That appears in the doc is short-term. You'll be able to click on it to alter the formatting of the pasted merchandise. To dismiss it, click any where else while in the document, press ESC , or commence typing. Another technique is to use the "Fill Deal with" feature. Simply https://mindmergeconnect.com/facts-about-how-to-mass-copy-and-paste-formulas-in-excel-revealed-3/