Hi, I have a huge word document which has so many tables and some text. I
want to convert this document into excel sheet.
Example: In 1 table the first column is "No." which needs as less space to
enter a single digit number, whereas in the next table, the first column has
some other data, that will need space for upto 15 words!!!!
This is when the problem arises. I cannot have the tables one below the
other in excel sheet.. Is there a method to optimise this???
PS. I have nearly 40 tables like this!!!
Thanks!!

Copy each table to a different worksheet, and auto-adjust column width.

HTH
--
AP

"Kazuki" a écrit dans le message de news:
...
Hi, I have a huge word document which has so many tables and some text. I
want to convert this document into excel sheet.
Example: In 1 table the first column is "No." which needs as less space to
enter a single digit number, whereas in the next table, the first column
has
some other data, that will need space for upto 15 words!!!!
This is when the problem arises. I cannot have the tables one below the
other in excel sheet.. Is there a method to optimise this???
PS. I have nearly 40 tables like this!!!
Thanks!!

Hi Ardus Petus, Thanks for your answer, but as I mentioned, I have over 40
tables and if I use different work sheets, it would distort the format of the
docuiment abruptly.
Can some one please help me with this?

"Ardus Petus" wrote:

Copy each table to a different worksheet, and auto-adjust column width.

HTH
--
AP

"Kazuki" a écrit dans le message de news:
...
Hi, I have a huge word document which has so many tables and some text. I
want to convert this document into excel sheet.
Example: In 1 table the first column is "No." which needs as less space to
enter a single digit number, whereas in the next table, the first column
has
some other data, that will need space for upto 15 words!!!!
This is when the problem arises. I cannot have the tables one below the
other in excel sheet.. Is there a method to optimise this???
PS. I have nearly 40 tables like this!!!
Thanks!!

You cannot have different column width within one column of a worksheet.

Cell merging makes things even worse.

HTH
--
AP

"Kazuki" a écrit dans le message de news:
...
Hi Ardus Petus, Thanks for your answer, but as I mentioned, I have over 40
tables and if I use different work sheets, it would distort the format of
the
docuiment abruptly.
Can some one please help me with this?

"Ardus Petus" wrote:

Copy each table to a different worksheet, and auto-adjust column width.

HTH
--
AP

"Kazuki" a écrit dans le message de
news:
...
Hi, I have a huge word document which has so many tables and some text.
I
want to convert this document into excel sheet.
Example: In 1 table the first column is "No." which needs as less space
to
enter a single digit number, whereas in the next table, the first
column
has
some other data, that will need space for upto 15 words!!!!
This is when the problem arises. I cannot have the tables one below the
other in excel sheet.. Is there a method to optimise this???
PS. I have nearly 40 tables like this!!!
Thanks!!

Hi AP, Thanks again. But actually I wanted to know whether there is any other
method to replace these tables.... and not to have different column widths
with 1 column.
Thanks.

"Ardus Petus" wrote:

You cannot have different column width within one column of a worksheet.

Cell merging makes things even worse.

HTH
--
AP

"Kazuki" a écrit dans le message de news:
...
Hi Ardus Petus, Thanks for your answer, but as I mentioned, I have over 40
tables and if I use different work sheets, it would distort the format of
the
docuiment abruptly.
Can some one please help me with this?

"Ardus Petus" wrote:

Copy each table to a different worksheet, and auto-adjust column width.

HTH
--
AP

"Kazuki" a écrit dans le message de
news:
...
Hi, I have a huge word document which has so many tables and some text.
I
want to convert this document into excel sheet.
Example: In 1 table the first column is "No." which needs as less space
to
enter a single digit number, whereas in the next table, the first
column
has
some other data, that will need space for upto 15 words!!!!
This is when the problem arises. I cannot have the tables one below the
other in excel sheet.. Is there a method to optimise this???
PS. I have nearly 40 tables like this!!!
Thanks!!