M
mcambrose
I imported an XML table into Excel. I need to expand the size of the table,
but the normal copy and insert copied cells is not available to use on an XML
table. The only way I found to do this is to open the xML task pane and
select a column heading in the XML map. The column of data is selected and a
black border surrounds the data included in the column. I can then drag the
corner of the border to resize. This causes an autofil of data in to the new
rows. NOt really a problem, but is there any other way to to this. It seems
that I can delete rows from XML table using the normal delete row method.
Thanks for any suggestions. If I am not clear, please ask and I will explain
further.
but the normal copy and insert copied cells is not available to use on an XML
table. The only way I found to do this is to open the xML task pane and
select a column heading in the XML map. The column of data is selected and a
black border surrounds the data included in the column. I can then drag the
corner of the border to resize. This causes an autofil of data in to the new
rows. NOt really a problem, but is there any other way to to this. It seems
that I can delete rows from XML table using the normal delete row method.
Thanks for any suggestions. If I am not clear, please ask and I will explain
further.