Jump to content

Recommended Posts

I am creating a catalogue and a couple of pages are just tables with technical data.
I have those tables as a Word file and as an Excel spreadsheet.

I am looking for a way to import them into Publisher AS TABLES, so I don't have to type out all the numbers in there.
I tried importing directly, but there's no such option.
I tried copy/paste but it gives me text that is not a table.

Help please!

Share this post


Link to post
Share on other sites

In Publisher create a table - keep it small, say, 3x3 cells

In Excel highlight the cells you want to copy and copy them

In Publisher select at least 2 cells then do Edit > Paste

The table in Publisher will expand to accommodate all the columns & rows pasted


Due to the fact that Boris Johnson is now our Prime Minister, punctuation, spelling and grammar will never be worried about ever again.  We now have far bigger problems to be concerned about.

Share this post


Link to post
Share on other sites
13 minutes ago, carl123 said:

In Publisher create a table - keep it small, say, 3x3 cells

In Excel highlight the cells you want to copy and copy them

In Publisher select at least 2 cells then do Edit > Paste

The table in Publisher will expand to accommodate all the columns & rows pasted

Works like a charm
Thank you very much!

Share this post


Link to post
Share on other sites

Tables should come as tables if you have a .docx file. If you have an .RTF file, they come as tab-separated paragraphs.

But I think that multipage tables are not supported.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

These are the Terms of Use you will be asked to agree to if you join the forum. | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.