Copying word tables of different column width to excel.

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" <[email protected]> a écrit dans le message de news:
[email protected]...
> 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" <[email protected]> a écrit dans le message de news:
> [email protected]...
> > 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" <[email protected]> a écrit dans le message de news:
[email protected]...
> 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" <[email protected]> a écrit dans le message de
>> news:
>> [email protected]...
>> > 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" <[email protected]> a écrit dans le message de news:
> [email protected]...
> > 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" <[email protected]> a écrit dans le message de
> >> news:
> >> [email protected]...
> >> > 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!!
> >>
> >>
> >>
>
>
>