A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I set a custom page size in Excel



 
 
Thread Tools Display Modes
  #1  
Old August 23rd 05, 07:28 AM
Ben Swift
external usenet poster
 
Posts: n/a
Default How do I set a custom page size in Excel

I have the US version of MS Office 2003, but I'm now living in Japan where
they use metric size papers. This is fine if I want to use B5/A4/A5 size
paper, but what I'm looking for is B4 or A1 or some of those other sized
papers. Why won't Excel let me set custom page size dimensions since it
doesn't have a preset for these sizes?
Ads
  #2  
Old August 23rd 05, 10:52 AM
Bryan Hessey
external usenet poster
 
Posts: n/a
Default


Ben,

I usually set my current printer to one that has the paper size
required, then the sheet size is simply selected from there.



Ben Swift Wrote:
> I have the US version of MS Office 2003, but I'm now living in Japan
> where
> they use metric size papers. This is fine if I want to use B5/A4/A5
> size
> paper, but what I'm looking for is B4 or A1 or some of those other
> sized
> papers. Why won't Excel let me set custom page size dimensions since
> it
> doesn't have a preset for these sizes?



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=398032

  #3  
Old August 23rd 05, 11:38 AM
Ben Swift
external usenet poster
 
Posts: n/a
Default

I'm not sure I follow exactly. I have an Okidata 14e, which supports those
metric page sizes, but I'm not sure what you mean by setting the printer to
use one of those paper sizes? I may be missing your point.

Ben

"Bryan Hessey" wrote:

>
> Ben,
>
> I usually set my current printer to one that has the paper size
> required, then the sheet size is simply selected from there.
>
>
>
> Ben Swift Wrote:
> > I have the US version of MS Office 2003, but I'm now living in Japan
> > where
> > they use metric size papers. This is fine if I want to use B5/A4/A5
> > size
> > paper, but what I'm looking for is B4 or A1 or some of those other
> > sized
> > papers. Why won't Excel let me set custom page size dimensions since
> > it
> > doesn't have a preset for these sizes?

>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=398032
>
>

  #4  
Old August 23rd 05, 12:28 PM
Bryan Hessey
external usenet poster
 
Posts: n/a
Default


Hi Ben,

I just installed the driver for the 14e, after re-reading your
questoin. To set a papersize the system follws the print device, and
not manyy printers can print odd size paper, so only standard sizes are
generally available. Adobe PDFWriter (and probably any .pdf
printer/writer) are printers that will accept custom sizes, though I'm
not sure many standard printers will.


A printer such as the Electrasoft NT Print to Fax shows a wide variety
of paper options.

Ben Swift Wrote:
> I'm not sure I follow exactly. I have an Okidata 14e, which supports
> those
> metric page sizes, but I'm not sure what you mean by setting the
> printer to
> use one of those paper sizes? I may be missing your point.
>
> Ben
>
> "Bryan Hessey" wrote:
>
> >
> > Ben,
> >
> > I usually set my current printer to one that has the paper size
> > required, then the sheet size is simply selected from there.
> >
> >
> >
> > Ben Swift Wrote:
> > > I have the US version of MS Office 2003, but I'm now living in

> Japan
> > > where
> > > they use metric size papers. This is fine if I want to use

> B5/A4/A5
> > > size
> > > paper, but what I'm looking for is B4 or A1 or some of those other
> > > sized
> > > papers. Why won't Excel let me set custom page size dimensions

> since
> > > it
> > > doesn't have a preset for these sizes?

> >
> >
> > --
> > Bryan Hessey
> >

> ------------------------------------------------------------------------
> > Bryan Hessey's Profile:

> http://www.excelforum.com/member.php...o&userid=21059
> > View this thread:

> http://www.excelforum.com/showthread...hreadid=398032
> >
> >



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=398032

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I save excel as HTML (but not as a full web page)? dls New Users to Excel 2 August 18th 05 12:07 AM
excel page breaks gone Tere01 Excel Discussion (Misc queries) 1 August 16th 05 09:25 PM
excel chart file size todicus Charts and Charting in Excel 0 July 20th 05 09:02 PM
changing page break in an excel file ibs81 New Users to Excel 1 April 14th 05 07:03 PM
Excel 2002 custom toolbars fick Excel Discussion (Misc queries) 4 December 13th 04 09:51 PM


All times are GMT +1. The time now is 10:03 AM.


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