Convert Excel spreadsheets to a Word table.
Usually, this is as simple as a cut and paste. But in this instance, the Excel sheet came to me already embedded into Word. In a normal world, you would double click the (Excel) table and it opens in Excel, then select and cut the table and paste it into Word (and pick the formatting option) to drop it in the doc. But all I got was a spinning ball, and a something-went-wrong message, creating a forced quit out of both Word and Excel.
This is the fix for converting an Excel spreadsheet to a table in Word.
To convert Excel sheets to word (at least with this doc, and, the MS version I have on the mac – which is Office 365 updated 2/16/2021)
- open Excel from Word
- copy Excel sheet into a new Excel doc
- copy and paste back into Word
- select format options (I used keep formatting)
This will convert the table from Excel to Word for the most part, but I found added spaces in the columns and changes in the justifications. Which is still a lot less work than completely rebuilding the table in Word.
Happy converting. Send me a comment.
