You have created the perfect table in MS Word and now you have to put it into MS Excel. You have tried copying and pasting but all of the pretty formatting is gone and it doesn’t fit right and it really looks a mess! What do you do now?
Well, this is quick and easy resolution and you will look like a star.
Simply paste your text into MS Excel as a picture! Hmmm…how do do that…
- In Excel 2007 and above go to the Home ribbon and click the down arrow on the Paste button and select Paste Special from the bottom of the list.
- Then select Picture from the list.
- Click OK.
Your text (or table) will now be placed in your Excel worksheet as a picture floating over the cells.
You will have the same resizing and moving capabilities as any other picture.
Pretty slick eh?