[Solved] converting excel spreadsheets to word tables

  • I have various spreadsheets and bits of spreadsheets in Excel that need to go into a Word document.


    I want to paste these as Word tables, simultaneously converting all the formulae to their values - but preferably keeping the border settings although this is purely optional.


    I'm probably being rather dense but what's the easiest way?

  • Hi,


    One thing I've found over the years is that when you copy a range of cells containing just numbers, for some reason Word sticks a load of spaces in front of the numbers. When you paste the table into word, you might need to replace spaces with nothing on those cells containing just numbers.


    John

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!