hi,
for speed, different users need to copy & paste text from various spreadsheets into
cells a:1 to a:10. the various spreadsheets have different formats which ruins the look of cells a:1 to a:10. how do i protect the format of a:1 to a:10? am aware that you can click the down arrow to the right and select values only after pasting but not every user knows or cares about this so it needs to be automatic.