Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > microsoft.public.excel.programming > #108759

Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it?

From GS <gs@v.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: Embed drawing toolbar textbox or word doc in sheet, how to refer to it?
Date 2016-04-16 02:01 -0400
Organization A noiseless patient Spider
Message-ID <neskad$ecj$1@dont-email.me> (permalink)
References <nertvh$ov7$1@dont-email.me> <nes322$6bv$1@dont-email.me> <nesirq$amg$1@dont-email.me>

Show all headers | View raw


> 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).

-- 
Garry

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

Back to microsoft.public.excel.programming | Previous | NextPrevious in thread | Next in thread | Find similar | Unroll thread


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