When I copy and paste the entire contents of an Excel worksheet into a new spreadsheet, I lose most (not all) of the formatting. The cell widths aren’t carried over, nor is most of the character formatting – font sizes, bolding, etc.
Help! How can I copy and paste so that all the original formatting is retained? I tried Paste Special>All, but that didn’t work
Thanks,
Julia (admittedly not a power user!)