| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Word copying info from Excel to Word without gridlines / bor | Excel Discussion (Misc queries) | |||
| Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
| Link table from excel to word using word VBA | Excel Discussion (Misc queries) | |||
| Excel Hyperlink doesn't open Word doc the same way as Word does | Excel Discussion (Misc queries) | |||
| Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) | |||
![Tricia LeAnn[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
