Extracting Excel Worksheet from Word Doc

  • Thread starter Thread starter Suzanne
  • Start date Start date
S

Suzanne

I inserted an Excel worksheet into a Word document by
Insert Object. When I Copy/Paste that Excel worksheet back
into Excel, I lose the column width formatting. Font and
border formatting are preserved.
Is there a way to also preserve column width when
extracting an Excel worksheet from Word?
 
I inserted an Excel worksheet into a Word document by
Insert Object. When I Copy/Paste that Excel worksheet back
into Excel, I lose the column width formatting. Font and
border formatting are preserved.
Is there a way to also preserve column width when
extracting an Excel worksheet from Word?

In Word, right-click on the inserted spreadsheet, and use:
Worksheet object >> Open

This opens the spreadsheet in a new Excel window.

In the Excel window, use:
File >> Save copy as

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top