formatting

[Guest]

I am trying to add the same format to another worksheet but have no idea how
to do it. Everytime I cut and paste to another sheet, my formatting is all
gone. Any suggestions?

 

[Guest]

If you are looking for just the formatting and not necessarily the data - try
Edit/Move or Copy Sheet. In the dialog box, click in the "To Book" a new
book and then make sure to check the bottom left check box "Create a copy".
The sheet will be copied with all the formatting intact. However, the data
will be linked to the original spreadsheet. From here you can highlight the
entire sheet and clear the contents and the formatting will stay.

Hope this helps

Amy

 

[Guest]

Right click where you want to paste and click "paste special". You will then
need to toggle on the formatting button.
This should do the trick.

Christopher

 

[Earl Kiosterud]

Confused,

It sounds as if you mean you're losing the formatting on the destination
sheet, instead of failing to carry the formatting from the source sheet
(which Excel does with either Cut/Paste or Copy/Paste). So your formatting
on the destination sheet is being overwritten by the formatting (even if
there isn't any) from the source. If this is the case, use Paste Special -
Values instead of Paste, to retain the formatting on the destination sheet.

 

[Gord Dibben]

Sometimes this involves two steps.

1. Copy and paste.

2. Copy and Paste Special>Formats.

Gord Dibben Excel MVP

 

[Guest]

Thank you everybody! The Create a Copy did the trick.