Say the area is from A1 thru B2.

Select A1 thru B2 on the first sheet and:

Edit Copy

then select cell A1 only on the second sheet and:

Edit Paste Special Formats.
--
Gary''s Student - gsnu200808


"DJ" wrote:

How can I copy a range of cells (some of which are filled with gray) from one
worksheet to another worksheet without deleting any data that may be in the
same range on the second sheet.