Maintaining readability after importing large Excel Table in Word

Dear Experts

I have two queries:

[1] I have many Excel table which each has 30 columns and 40 rows, and within each cell there are 5 digit numbers. I am seeking your help with the best way to bring each table to a Word document so that it remains readable.

Currently, I am selecting each table in Excel and try to paste as picture in the Word document but the numbers and texts are becoming very small after resizing and is difficult to read. Also, the quality of pasted picture is not good. What is your advice?

In A4 Landscape page in Microsoft Word, I have 4 cm gap on top and 2 cm in other sides. Therefore, I have to fit the table in this area.

[2] Also, when I bring graphs from Excel into my Word document and they are linked to the source in Excel, the size of Word document become very large. What is the best way to reduce size? I tried to copy as picture using PNG or JPG or Word metafile format but I am not happy with the quality of the picture, but when I paste it as Excel object or when I copy using the word option which says retain source formatting the quality is very good but the doc size is becoming very large.

I look forward to receiving your feedback and ideas as the best way to tackle the issue .

Many thanks in advance

Hi Paul
Thanks for your reply, but there should be some creative ways of getting the tables more readable. Long time ago, I came across documents that people managed to place similar size tables (say 40 rows by 30 columns) on a landscape paper in Word and they were nice and readable. This is why I am posting my queries that maybe someone can assist with a creative way. Nevertheless, I agree with you by re-sizing we lose resolution and readability.

Regards