A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I set a custom page size in Excel



 
 
Thread Tools Display Modes
  #1  
Old August 23rd, 2005, 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, 2005, 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, 2005, 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, 2005, 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 Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Open excel from htm page den General Discussion 0 April 25th, 2005 11:58 PM
custom label page size in mail merge (on a mac) Beee Mailmerge 1 January 7th, 2005 05:56 AM
MAC: different page size in 1 document, spool each page size a 1 j phn737 Page Layout 1 August 23rd, 2004 11:58 PM
Save as Web Page in Excel 2002 Bob New Users 1 June 23rd, 2004 02:49 PM
Save as Web PAge in Excel 2002 Bob General Discussion 1 June 22nd, 2004 06:41 PM


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


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