Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #108760
| From | Mike S <mscir@yahoo.com> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? |
| Date | 2016-04-15 23:39 -0700 |
| Organization | A noiseless patient Spider |
| Message-ID | <nesmgi$jj1$1@dont-email.me> (permalink) |
| References | <nertvh$ov7$1@dont-email.me> <nes322$6bv$1@dont-email.me> <nesirq$amg$1@dont-email.me> <neskad$ecj$1@dont-email.me> |
On 4/15/2016 11:01 PM, GS wrote: >> On 4/15/2016 6:07 PM, GS wrote: >>> Is there any reason you can't use a worksheet to format your report? >> >> I will have multiple pages and I don't know how to paginate an Excel >> worksheet. Can I embed pagebreaks in the worksheet? If so that might >> work. > > Yes, you absolutely can place manual pagebreaks. In v2003< it's on the > Insert menu. In v2007> it's on the Page Layout tab. One caveat is you > need to pay attention that your manual pagebreaks aren't screwed up by > the default ones, meaning you may have to remove some so your page > 'flow' goes how you want. Once you PrintPreview, the print_area and > pagebreaks appear on your worksheet and so can use these as guides for > setting pagination. > > For viewing in the worksheet you can turn off gridlines so your page > appears like a word processor (sort of). Thank you for the detailed explanation. I'll look into this and see if this is easier than automating Word outside of the workbook.
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Embed drawing toolbar textbox or word doc in sheet, how to refer to it? Mike S <mscir@yahoo.com> - 2016-04-15 16:40 -0700
Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? GS <gs@v.invalid> - 2016-04-15 21:07 -0400
Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? Mike S <mscir@yahoo.com> - 2016-04-15 22:37 -0700
Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? GS <gs@v.invalid> - 2016-04-16 02:01 -0400
Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? Mike S <mscir@yahoo.com> - 2016-04-15 23:39 -0700
Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? GS <gs@v.invalid> - 2016-04-16 06:34 -0400
Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? GS <gs@v.invalid> - 2016-04-16 07:21 -0400
Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it? Mike S <mscir@yahoo.com> - 2016-04-16 22:14 -0700
csiph-web