Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 26th 17, 12:34 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2009
Posts: 77
Default Spreadsheet With Multiple Columns To WORD as a Single Page Width ?

Hello,

Not sure if this should be asked in the WORD group, or here.
But have gotten such good help here in the past, will try here.

Using Excel 2007.
Old, but does most everything I need.

I have a spreadsheet that extends over quite a few columns.

What I want to do is to "compress" the spreadsheet, so that all columns
will fit into a document (WORD) that is already formatted for the normal
8-1/2 x 11 page.

Playing with View, etc. in the spreadsheet, I have been able to have all
the columns show up on a single page width.
Great.

I then do a Copy, and try pasting it into the existing WORD doc.
It refuses to Paste what I have selected as a single page width.

Not all that sharp with this.

How would I go about pasting what I have selected in Excel, and is what
I want, into WORD so it shows up as what I have formatted, and selected
in Excel; namely a single page width (with a smaller font of course
which I assume would be done automatically) ?

Thanks,
B.

  #2   Report Post  
Old October 26th 17, 05:44 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,058
Default Spreadsheet With Multiple Columns To WORD as a Single Page Width ?

Hello,

Not sure if this should be asked in the WORD group, or here.
But have gotten such good help here in the past, will try here.

Using Excel 2007.
Old, but does most everything I need.

I have a spreadsheet that extends over quite a few columns.

What I want to do is to "compress" the spreadsheet, so that all columns
will fit into a document (WORD) that is already formatted for the normal
8-1/2 x 11 page.

Playing with View, etc. in the spreadsheet, I have been able to have all the
columns show up on a single page width.
Great.

I then do a Copy, and try pasting it into the existing WORD doc.
It refuses to Paste what I have selected as a single page width.

Not all that sharp with this.

How would I go about pasting what I have selected in Excel, and is what I
want, into WORD so it shows up as what I have formatted, and selected in
Excel; namely a single page width (with a smaller font of course which I
assume would be done automatically) ?

Thanks,
B.


It would be easier to put your Word content onto the worksheet and choose 'fit
to 1 page' wide by however many pages tall!(IMO) You could insert the cols as a
table and resize it to fit your Word page, but not sure that's as reliable. (I
don't use Word because Excel does everything I need for word processing + all
its builtin features as well!)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
columns width in a single vba statement Fcoatis Excel Programming 3 January 13th 14 07:33 PM
print a multi paged excel spreadsheet width onto one page libramieke Excel Discussion (Misc queries) 4 March 18th 08 01:53 PM
How do I paste a multi page width worksheet into Word? Report Goddess Excel Discussion (Misc queries) 0 October 19th 06 10:49 PM
Adjust an Excel table with the width of a Word page [email protected] Excel Discussion (Misc queries) 1 August 2nd 05 10:24 AM


All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017