Tables pasting info in Calibri instead of tables existing style (paste without formatting pastes in one cell too)

[Alex P]

Hi! I've been looking for the answer to this problem for a while now, but I haven't been able to find one or work it out on my own. I'm hoping someone here will have a solution.

The Problem: I have a table set with a specific font and size in my document. When I copy and paste the data from an Excel sheet into this table, it pastes it as Calibri and a different size. I thought I should try "paste without formatting", but this was worse, and it pasted the 20+ cells into one and still ignored my table style. I work in tables across 10-15 pages in a very fast-paced office, so I cannot lose valuable time manually adjusting all the styles again, and table styles don't always work (I think that's a bug). 

Unfortunately, due to the nature of my work, I can't post screen grabs or the documents themselves, but hopefully, I was descriptive enough to get the idea across. Does anyone know how to fix this? 

Edited September 23, 2024 by Alex P

[Hangman]

Hi @Alex P and welcome to the forums,

Is this in Windows or Mac?

Table formatting in general is not great in Publisher but I just ran a quick copy/paste from Excel into a Publisher table and Calibri pasted everything at the same font size...

Another possible option might be to place the .xlsx file directly into Publisher which gives you a fully editable Table...

[Alex P]

7 minutes ago, Hangman said:

Hi @Alex P and welcome to the forums,

Is this in Windows or Mac?

Table formatting in general is not great in Publisher but I just ran a quick copy/paste from Excel into a Publisher table and Calibri pasted everything at the same font size...

Another possible option might be to place the .xlsx file directly into Publisher which gives you a fully editable Table...

Sorry, I should have mentioned it's on Windows. The trouble is that I do NOT want Calibri. I use a different font, but for some reason, it always ends up replacing that font with Calibri. I work out of an Excel workbook provided by my data analyst, so I can't easily separate the pages to make them stand-alone sheets since it's a shared doc (I think, that is, I'm not the best at understanding Excel).

Edited September 23, 2024 by Alex P

[Hangman]

2 minutes ago, Alex P said:

Sorry, I should have mentioned it's on Windows. The trouble is that I do NOT want Calibri. I use a different font, but it always ends up replacing that font with Calibri for some reason. I work out of an Excel workbook provided by my data analyst, so I can't easily separate the pages.

This is the general issue I've found with Publisher Tables, you can't select cells, set text styles and then paste your source content and have it match your Excel sheet but if you set text styles for Table Headers and Table Body in Publisher you can paste then apply the text styles accordingly...

Not ideal but possibly the quickest workaround...

[Alex P]

1 minute ago, Hangman said:

This is the general issue I've found with Publisher Tables, you can't select cells, set text styles and then paste your source content and have it match your Excel sheet but if you set text styles for Table Headers and Table Body in Publisher you can paste then apply the text styles accordingly...

Not ideal but possibly the quickest workaround...

Ah, I see. It's good to know I'm not going crazy for no reason. Hopefully, that's something they can work on in the future. Thank you so much for the quick help!

[Hangman]

Just now, Alex P said:

Ah, I see. It's good to know I'm not going crazy for no reason. Hopefully, that's something they can work on in the future. Thank you so much for the quick help!

No problem... I'd love to see some improvements with table formatting as well...