Copying and Pasting Formated columns and Rows

So, I have a document 25 pages long. It has 26 sections (1-26) and each section has up to 10 (.1 - .10) sub sections which contain 16 (a-p) sub-sub-sections. There are 6 columns of varying widths. Some cells, in a row, merge into adjacent cells.

I would like to break this document into 26 documents - one for each section - so that I may recombine and regroup them in the future incorporating a few modifications. Whenever I copy and paste to a new Workbook, I loose the formatting of column widths. Resetting these alone takes lots of time.

The only solution I have come up with is to duplicate the entire document and delete everything above and below the section I would like to save. Then repeat for next section. There's got to be a better way?

Any help?



Frankie

Tried it with all columns, individually, and column width was not applied. Very frustrating.

F

I did not because that method would copy the entire column. Instead, I would like to copy only a portion of columns A - F, say rows 379 - 463.

Explanation makes perfect sense.
Execution - notsomuch.

If I click on the top left corner I get the entire document highlighted. This gets copied and pasted to new workbook. Easier to simply make a copy by doing Save As…

I think I'm not copying the Format, but rather copying the entire document. How do I copy just the format?

FDibbins -

Brilliant! Been struggling this for weeks and didn't see the 2-part solution. Thank you. Everyone in the office will be quite impressed when I demonstrate this tomorrow!

Thanks again.