ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Word to Excel! (https://www.excelbanter.com/excel-discussion-misc-queries/175922-word-excel.html)

Tricia LeAnn[_2_]

Word to Excel!
 
I have about 100 tables in Word that I need put into Excel. When I copy and
paste them, the cells are WAY too big, and I have to go back and resize it
each time. Is there and easier way for me to do this?
--
Have a fantastic day!

Tricia LeAnn

MrAcquire

Word to Excel!
 
Data - TextToColumns
Then Format-Column-AutoFitSelection

This assumes that you pasted the data as one column of data.

"Tricia LeAnn" wrote:

I have about 100 tables in Word that I need put into Excel. When I copy and
paste them, the cells are WAY too big, and I have to go back and resize it
each time. Is there and easier way for me to do this?
--
Have a fantastic day!

Tricia LeAnn



All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com