PC Review


Reply
Thread Tools Rate Thread

Document issues

 
 
rkovelman
Guest
Posts: n/a
 
      17th Mar 2008
I have a document where we have multiple issues. When we go to resize
a "box" with text in it, it will not make the box big to fit all the
characters in it, just the last few lines. Also when we print this
document on 11x17 it prints it on the right paper just makes the text
small and does not fill the entire sheet. Any ideas how to solve this?
 
Reply With Quote
 
 
 
 
Gord Dibben
Guest
Posts: n/a
 
      17th Mar 2008
Assuming a "box" is a "cell", the maximum numbers or characters that can be
placed in a cell is 32767 but...........by default only 1024 will show or can be
printed.

Add an Alt + Enter(linefeed) every 100 characters to increase this 1024 limit.

If your printer supports 11x17 paper make sure that your settings at File>Page
Setup>Page are correct.........paper size..........adjust to %..........fit to.


Gord Dibben MS Excel MVP

On Mon, 17 Mar 2008 07:55:25 -0700 (PDT), rkovelman <(E-Mail Removed)>
wrote:

>I have a document where we have multiple issues. When we go to resize
>a "box" with text in it, it will not make the box big to fit all the
>characters in it, just the last few lines. Also when we print this
>document on 11x17 it prints it on the right paper just makes the text
>small and does not fill the entire sheet. Any ideas how to solve this?


 
Reply With Quote
 
rkovelman
Guest
Posts: n/a
 
      17th Mar 2008
With the adjust to %, that keeps going to 35% or around that. How do
I know what to put that to? Is 100% to big? I want to maximize it to
fit the page. The document is also adding page breaks even though I
did not put them there.
Thanks

On Mar 17, 3:20*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> Assuming a "box" is a "cell", the maximum numbers or characters that can be
> placed in a cell is 32767 but...........by default only 1024 will show or can be
> printed.
>
> Add an Alt + Enter(linefeed) every 100 characters to increase this 1024 limit.
>
> If your printer supports 11x17 paper make sure that your settings at File>Page
> Setup>Page are correct.........paper size..........adjust to %..........fit to.
>
> Gord Dibben *MS Excel MVP
>
> On Mon, 17 Mar 2008 07:55:25 -0700 (PDT), rkovelman <rkovel...@gruskingroup.com>
> wrote:
>
> >I have a document where we have multiple issues. *When we go to resize
> >a "box" with text in it, it will not make the box big to fit all the
> >characters in it, just the last few lines. *Also when we print this
> >document on 11x17 it prints it on the right paper just makes the text
> >small and does not fill the entire sheet. *Any ideas how to solve this?


 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      18th Mar 2008
100% is not too big if it fits the page.

200% is not too big if it fits the page.

Only you know what print area you have set and how much data range must be
printed.

The page breaks are most likely a function of your settings in Page Setup.

Hard to tell from here.

In View>PageBreak View can you drag the blue lines around?

What are the margin settings under the Margins Tab in File>Page Setup.

What is the range under Print Area on the Margins Tab?


Gord

On Mon, 17 Mar 2008 15:57:00 -0700 (PDT), rkovelman <(E-Mail Removed)>
wrote:

>With the adjust to %, that keeps going to 35% or around that. How do
>I know what to put that to? Is 100% to big? I want to maximize it to
>fit the page. The document is also adding page breaks even though I
>did not put them there.
>Thanks
>
>On Mar 17, 3:20*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
>> Assuming a "box" is a "cell", the maximum numbers or characters that can be
>> placed in a cell is 32767 but...........by default only 1024 will show or can be
>> printed.
>>
>> Add an Alt + Enter(linefeed) every 100 characters to increase this 1024 limit.
>>
>> If your printer supports 11x17 paper make sure that your settings at File>Page
>> Setup>Page are correct.........paper size..........adjust to %..........fit to.
>>
>> Gord Dibben *MS Excel MVP
>>
>> On Mon, 17 Mar 2008 07:55:25 -0700 (PDT), rkovelman <rkovel...@gruskingroup.com>
>> wrote:
>>
>> >I have a document where we have multiple issues. *When we go to resize
>> >a "box" with text in it, it will not make the box big to fit all the
>> >characters in it, just the last few lines. *Also when we print this
>> >document on 11x17 it prints it on the right paper just makes the text
>> >small and does not fill the entire sheet. *Any ideas how to solve this?


 
Reply With Quote
 
rkovelman
Guest
Posts: n/a
 
      18th Mar 2008
I can move the page breaks to meet the page lines. But why do they
appear. When I move them they just move back.
~Ross


On Mar 17, 11:43*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> 100% is not too big if it fits the page.
>
> 200% is not too big if it fits the page.
>
> Only you know what print area you have set and how much data range must be
> printed.
>
> The page breaks are most likely a function of your settings in Page Setup.
>
> Hard to tell from here.
>
> In View>PageBreak View can you drag the blue lines around?
>
> What are the margin settings under the Margins Tab in File>Page Setup.
>
> What is the range under Print Area on the Margins Tab?
>
> Gord
>
> On Mon, 17 Mar 2008 15:57:00 -0700 (PDT), rkovelman <rkovel...@gruskingroup.com>
> wrote:
>
> >With the adjust to %, that keeps going to 35% or around that. *How do
> >I know what to put that to? *Is 100% to big? *I want to maximize it to
> >fit the page. *The document is also adding page breaks even though I
> >did not put them there.
> >Thanks

>
> >On Mar 17, 3:20*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
> >> Assuming a "box" is a "cell", the maximum numbers or characters that can be
> >> placed in a cell is 32767 but...........by default only 1024 will show or can be
> >> printed.

>
> >> Add an Alt + Enter(linefeed) every 100 characters to increase this 1024limit.

>
> >> If your printer supports 11x17 paper make sure that your settings at File>Page
> >> Setup>Page are correct.........paper size..........adjust to %...........fit to.

>
> >> Gord Dibben *MS Excel MVP

>
> >> On Mon, 17 Mar 2008 07:55:25 -0700 (PDT), rkovelman <rkovel...@gruskingroup.com>
> >> wrote:

>
> >> >I have a document where we have multiple issues. *When we go to resize
> >> >a "box" with text in it, it will not make the box big to fit all the
> >> >characters in it, just the last few lines. *Also when we print this
> >> >document on 11x17 it prints it on the right paper just makes the text
> >> >small and does not fill the entire sheet. *Any ideas how to solve this?


 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      18th Mar 2008
What is a "page line"?

The breaks appear where Excel thinks they should be based upon your print area
and page setup and margins with your particular printer and selected paper size
and orientation.


Gord

On Tue, 18 Mar 2008 05:46:32 -0700 (PDT), rkovelman <(E-Mail Removed)>
wrote:

>I can move the page breaks to meet the page lines. But why do they
>appear. When I move them they just move back.
>~Ross
>
>
>On Mar 17, 11:43*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
>> 100% is not too big if it fits the page.
>>
>> 200% is not too big if it fits the page.
>>
>> Only you know what print area you have set and how much data range must be
>> printed.
>>
>> The page breaks are most likely a function of your settings in Page Setup.
>>
>> Hard to tell from here.
>>
>> In View>PageBreak View can you drag the blue lines around?
>>
>> What are the margin settings under the Margins Tab in File>Page Setup.
>>
>> What is the range under Print Area on the Margins Tab?
>>
>> Gord
>>
>> On Mon, 17 Mar 2008 15:57:00 -0700 (PDT), rkovelman <rkovel...@gruskingroup.com>
>> wrote:
>>
>> >With the adjust to %, that keeps going to 35% or around that. *How do
>> >I know what to put that to? *Is 100% to big? *I want to maximize it to
>> >fit the page. *The document is also adding page breaks even though I
>> >did not put them there.
>> >Thanks

>>
>> >On Mar 17, 3:20*pm, Gord Dibben <gorddibbATshawDOTca> wrote:
>> >> Assuming a "box" is a "cell", the maximum numbers or characters that can be
>> >> placed in a cell is 32767 but...........by default only 1024 will show or can be
>> >> printed.

>>
>> >> Add an Alt + Enter(linefeed) every 100 characters to increase this 1024 limit.

>>
>> >> If your printer supports 11x17 paper make sure that your settings at File>Page
>> >> Setup>Page are correct.........paper size..........adjust to %..........fit to.

>>
>> >> Gord Dibben *MS Excel MVP

>>
>> >> On Mon, 17 Mar 2008 07:55:25 -0700 (PDT), rkovelman <rkovel...@gruskingroup.com>
>> >> wrote:

>>
>> >> >I have a document where we have multiple issues. *When we go to resize
>> >> >a "box" with text in it, it will not make the box big to fit all the
>> >> >characters in it, just the last few lines. *Also when we print this
>> >> >document on 11x17 it prints it on the right paper just makes the text
>> >> >small and does not fill the entire sheet. *Any ideas how to solve this?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Issues with new document in Word 2007 Gary Microsoft Word Document Management 3 2nd Mar 2010 06:26 PM
Re: Excel document - compatibilty issues - please help CB Windows Vista Performance 0 23rd Jan 2008 12:51 AM
shared document: protection issues =?Utf-8?B?QXJuZQ==?= Microsoft Excel Programming 1 30th May 2007 05:39 PM
Document Merge Issues Barb Reinhardt Microsoft Word Document Management 1 13th Oct 2004 10:59 AM
Master/sub document header issues Walipala Microsoft Word Document Management 6 13th Sep 2004 12:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:59 PM.