Excel 2007 copy/paste

Money_Saver

Hello

I am wanting to copy and paste data from Excel 2007 into Word 2007. Now, the bit that is confusing for me is, I want to copy the Gridlines as well. When I highlight the data, select copy, and then paste into Excel, it does what it's told, but minus the gridlines. Is there an option that I have to check so they appear too?

Thanks in advance for your suggestions/help

mj12_2

Money_Saver wrote: »

Hello

I am wanting to copy and paste data from Word 2007 into Excel 2007. Now, the bit that is confusing for me is, I want to copy the Gridlines as well. When I highlight the data, select copy, and then paste into Excel, it does what it's told, but minus the gridlines. Is there an option that I have to check so they appear too?

Thanks in advance for your suggestions/help

Do you mean copying a table from word to excel? if so it should show gridlines automatically, if not you can add them using the formatting option (select the cells you want to grid and right click then on the menu select 'format cells', then look for the border tab)

Money_Saver

mj12 wrote: »

Do you mean copying a table from word to excel? if so it should show gridlines automatically, if not you can add them using the formatting option (select the cells you want to grid and right click then on the menu select 'format cells', then look for the border tab)

Sorry, from Excel to word

victor2

When you say gridlines, do you mean you are copying a table from Word into Excel? Easiest way is to select the table in word, copy then past in Excel and it will occupy the corresponding number of cells as the table had. Or are you pasting it as an image?

Scrap that, just seen the other responses!

mj12_2

Money_Saver wrote: »

Sorry, from Excel to word

In that case im not 100% sure, in Word/Excel 2010 if you copy from excel to word it automatically keeps the data in table format but loses the gridlines, if i then right click on the data and select borders and shading I can add gridlines back again.

i'm not sure if 2007 works in the same way though

victor2

Money_Saver wrote: »

Sorry, from Excel to word

So long as the cells in Excel are formatted with borders, not just the gridlines, which are there for guidance and not normally printed, it should copy and paste into Word with the borders as defined.

Money_Saver

Thanks everybody it's worked

Brill!