Excel Copy Question

I am trying to copy a range of cells from one Excel Workbook to a new workbook. I can do this, but when I do it doesn’t copy all the formatting (it doesn’t make an exact copy) and I have to reformat the copy. There has to be an easier way . . .