Excel will then place a dotted line around ... Formatting Copied From Formatting Pasted To Result One cell If the selected area for pasting the formatting is larger than the copied range, the ...

It may also result in more printed pages when you print the workbook. To avoid this, reset that last cell by switching to the Clean Excess Cell Formatting command on Excel’s Inquire tab.