When I copy a part of a file and paste it in a new sheet it loses the format and becomes a jumble. Does anyone know how to fix this?
Couple ways to do it, both pretty well summarized here:
I cant get that to work. I’m trying to keep my columns, but I don’t know if format painter even knows that. Format is about cells, but columns?
For some reason you lose the paste function when you choose format painter in a new sheet. I don’t know what command to do first to have functions work.
Anyway I’m trying to paste some part of a file in a new sheet and print. It loses the columnization and I can’t get it back.
I’m just trying to print now form the original doc and it won’t do that. It shows a part fo the file that is not “chosen” I have no idea why.
Yeah I chose my selection. Hit format painter. Chose it to “copy” Went to the other sheet. Hit format painter. Pasted the selection. It still loses all columnization.
If I’m understanding you correctly, try this instead (ie, I don’t think what you did was the correct procedure for format painter):
To quickly copy the format of the entire column, select the heading of the column whose formatting you want to copy, click Format Painter , and then click the heading of the target column.
[from the linked article]
What about when you have 8 columns and want to keep the relationships between them?
I don’t understand one reason why anyone would ever want to lose the format like that by pasting. Don’t know why it would ever default that way.
I just used format painter to paint the formats from three contiguous columns in Workbook 1 to three contiguous columns in Workbook 2 (ie, a newly-created, separate workbook).
It worked for me.