copying to Word

Feb 27th, 2002, 01:53 PM

I have data in Excel workbooks/sheets and need to copy the data, format and font style into a Word document (annual report) without copying the formulas (file size gets too large in Word). Cut and paste doesn't bring the format or fonts - just the data and formulas. This is very time consuming as I have to spend time reformatting the data.

Feb 27th, 2002, 02:04 PM

Have you tried copying formats and data only into another Excel spreadsheet using paste special and then copying that into Word?

Jack in the UK · Feb 27th, 2002, 02:09 PM

Hi --

First a big sorry to them who love WORD!

I hate it and REFUSE to use Word evn load on my PC. BUT

Look Why go to Word? Excel can do all that and far more, i write letter in Excel!

If you set Excel correctly then NO ONE wil ltell the difference, let me know if you need help, i do this all day everyday..

Even for Legal works, no one even knows unless they see me that is.

Anne Troy · Feb 27th, 2002, 02:16 PM

LOL, Jack! (don't look at my signature!!)

Why don't you Paste special--Paste as Excel object?

Feb 27th, 2002, 02:16 PM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	LOL, Jack! (don't look at my signature!!) Why don't you Paste special--Paste as Excel object? __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 01:53 PM	#1
Guest Posts: n/a	I have data in Excel workbooks/sheets and need to copy the data, format and font style into a Word document (annual report) without copying the formulas (file size gets too large in Word). Cut and paste doesn't bring the format or fonts - just the data and formulas. This is very time consuming as I have to spend time reformatting the data.

Feb 27th, 2002, 02:04 PM	#2
Guest Posts: n/a	Have you tried copying formats and data only into another Excel spreadsheet using paste special and then copying that into Word?

Feb 27th, 2002, 02:09 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi -- First a big sorry to them who love WORD! I hate it and REFUSE to use Word evn load on my PC. BUT Look Why go to Word? Excel can do all that and far more, i write letter in Excel! If you set Excel correctly then NO ONE wil ltell the difference, let me know if you need help, i do this all day everyday.. Even for Legal works, no one even knows unless they see me that is.