Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Importing Tables from Word to Excel

I have a table which is in Word document and I want to import it into Excel
as a header. Is this possible? If this is not possible how can I import the
table into the document without messing up the cell formatting I already have?
I need this table to appear on each printed page (approximately 20 pages)
however everytime I have tried to import the table the formatting that has
been previously established by the Excel document becomes distorted.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Importing Tables from Word to Excel

Maybe...

You could copy the MSWord table.
Then paste that table into excel as a picture.

In xl2003, I shift-click on Edit and use Paste Picture.

This isn't used with file|Page setup|headers and footers. It's used to paste
over the worksheet.

Will Payton wrote:

I have a table which is in Word document and I want to import it into Excel
as a header. Is this possible? If this is not possible how can I import the
table into the document without messing up the cell formatting I already have?
I need this table to appear on each printed page (approximately 20 pages)
however everytime I have tried to import the table the formatting that has
been previously established by the Excel document becomes distorted.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Importing Tables from Word to Excel

I actually did try making a picture as you suggest but I need to be able to
edit the table I am pasting. I am setting up a template in which a multitude
of people will use once it is completed. But good suggestion.

"Dave Peterson" wrote:

Maybe...

You could copy the MSWord table.
Then paste that table into excel as a picture.

In xl2003, I shift-click on Edit and use Paste Picture.

This isn't used with file|Page setup|headers and footers. It's used to paste
over the worksheet.

Will Payton wrote:

I have a table which is in Word document and I want to import it into Excel
as a header. Is this possible? If this is not possible how can I import the
table into the document without messing up the cell formatting I already have?
I need this table to appear on each printed page (approximately 20 pages)
however everytime I have tried to import the table the formatting that has
been previously established by the Excel document becomes distorted.


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Importing Tables from Word to Excel

I'm out of ideas.

Will Payton wrote:

I actually did try making a picture as you suggest but I need to be able to
edit the table I am pasting. I am setting up a template in which a multitude
of people will use once it is completed. But good suggestion.

"Dave Peterson" wrote:

Maybe...

You could copy the MSWord table.
Then paste that table into excel as a picture.

In xl2003, I shift-click on Edit and use Paste Picture.

This isn't used with file|Page setup|headers and footers. It's used to paste
over the worksheet.

Will Payton wrote:

I have a table which is in Word document and I want to import it into Excel
as a header. Is this possible? If this is not possible how can I import the
table into the document without messing up the cell formatting I already have?
I need this table to appear on each printed page (approximately 20 pages)
however everytime I have tried to import the table the formatting that has
been previously established by the Excel document becomes distorted.


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing from excel to word Kenike Excel Discussion (Misc queries) 2 November 30th 07 08:10 PM
Importing a Word Document into Excel Depechez New Users to Excel 0 September 8th 06 05:30 PM
Importing diagram from Excel to Word Omkar Excel Worksheet Functions 3 July 7th 06 09:47 PM
Importing Tables from Access into Excel using Macros or VBA CLamar Excel Discussion (Misc queries) 4 May 23rd 06 09:23 PM
Importing Word doc into Excel Solimar Excel Discussion (Misc queries) 3 March 26th 06 08:50 PM


All times are GMT +1. The time now is 10:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"