Well, I've worked on this all day and come up close but no cigar. I'm in Excel 2007.
I built a single sheet to house a page showing a selection of foods in various food groups. Each food section grid is bordered and there are columns/rows with specific sizings for spacing. No formulas in use. There are a couple of graphics laid on blank areas (in text boxes) that need to propagate. I thought this would be sooo easy! Well....
I need to wind up with a second workBOOK that has 6 tabs. Each tab must contain a copy of the original single I just fine tuned. Yet, when I select ALL out of the original, copy and then paste it in to tab A, it comes out with standard formatting and no graphics. The formatting and bordering is left out. Looks awful. And, I was so proud. :-)
I wondered about Format Painter but it fails so that isn't the right answer. Why can I not just copy and paste? I will gladly manually add in the graphic elements as I realize those really aren't spreadsheet elements per se. Yes, I tried Paste Special too.
I thought I'd done something like this for another project years back with an older version of Excel. But apparently I'm behind the times with this newer version that I thought I understood.
What's the secret good people. I'm betting there's a really simple answer that I'm simply overlooking...