Formatting data from excel sheet

[robsanders]

Hello all,

More of a query if anything but wanted to see if someone could point me in the right direction.

I am putting a price list together for work, which has the variable of discounted prices dependent on customer. All this is done in Excel, but wanted to know the best way to merge into a layout/format for Word so it could be presented a little better than the look of cells across the page.

Would this be possible to do in Word or could i setup a template in Word to import the relevant cells?

Regards
Rob

 

[kate12402]

Okay so my understanding of this is that you still want a table in a Word document, just you want it to look better? Two options I can think of:

1. Insert Excel spreadsheet It would end up looking like this:

With this, you get all the functionality of an Excel spreadsheet, and all the prettiness of a table in Word This is good if you want to be able to update this spreadsheet in the Word doc later. After you Insert > Table > Excel Spreadsheet (which will insert a blank spreadsheet), you can copy/paste your content from excel into this table.

2. Copy/Paste content

Or you could literally highlight the applicable columns and paste them into Word. That will automatically put them in a table. It'll look exactly the same, the only difference is the conditional formatting doesn't stay with it. So if you've got a formula, or a special cell set up for currency or percent, it doesn't stay. So while it may look like $ 12.00 right now, when you go to change the cell, it's nothing more than dollar sign space space space space number number period number number.

It's really just a question of whether or not you want to be updating this information in the Word doc. If not, super easy, just copy/paste. And then you can edit the table to make it pretty, put in some borders, shading, change the font, whatever

Hope this helped!

 

[kate12402]

If this is something you do often, (i.e., import data from the same Excel spreadsheet into the same Word spreadsheet), then check out this Website: http://www.makeuseof.com/tag/integrate-excel-data-word-document/

The setup for this might take a little while to get right, but you'd save a ton of time in the long run.