 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Printing / July 2005Custom page sizes in Excel
Back in the old days of Lotus 123 for Windows, I could set a custom page size - basically, any size page I wanted - and print that size (such as 4" x 5") - can't see ANY way to do that in Excel - this is a major shortcoming. Anyway to do this??  SignatureMike Matheny Hi Mike, Don't know what you did with Lotus 1-2-3, but Excel is the same as in many other applications programs, across Office and elsewhere they feed on one another and have pretty much the same options: File, Page Setup then specifically for Excel the page tab, and within that the paper size. This applies to the worksheet you are in. Take that back a bit -- but this is also common elsewhere, the paper size does not offer a custom size of your own, you will find that on the Options button on File, Page Setup, Page tab but this is into and up to your print driver from the printer manufacturer. If you want something for future usage you could use a template, but I don't think you want that odd size as a default anyway. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Back in the old days of Lotus 123 for Windows, I could set a custom page > size - basically, any size page I wanted - and print that size (such as 4" x > 5") - can't see ANY way to do that in Excel - this is a major shortcoming. > Anyway to do this?? Word has the ability to specify a custom page size - so, if as you state that the programs are interoperable, I would think that this would be an 'interoperable' kind of option. SignatureMike Matheny > Hi Mike, > Don't know what you did with Lotus 1-2-3, but Excel is the same as in [quoted text clipped - 23 lines] >> shortcoming. >> Anyway to do this?? Hi Mike, And you could not set a custom page size starting from the File, Page Setup, Page tab, Options button interesting. I guess there are big differences in printer drivers. I didn't use the word "interoperable" you had me wondering if I'd lost a lot of brain cells between then and now, or between one ear and the other. > Word has the ability to specify a custom page size - so, if as you state > that the programs are interoperable, I would think that this would be an > 'interoperable' kind of option. Nope - HP8150, only get pre-set page sizes! What printer are you using that you can specify a specific page size?? SignatureMike Matheny > Hi Mike, > And you could not set a custom page size starting from the [quoted text clipped - 7 lines] >> that the programs are interoperable, I would think that this would be an >> 'interoperable' kind of option. One more thing - this is a printer shared off of a Win2K3 server, if that makes any difference. SignatureMike Matheny > Nope - HP8150, only get pre-set page sizes! What printer are you using > that you can specify a specific page size?? [quoted text clipped - 12 lines] >>> that the programs are interoperable, I would think that this would be an >>> 'interoperable' kind of option. Well, the Custom button is grayed out, and the little Exclamation point says that feature is not available because I don't have permission to save system settings on that computer - 'that computer' is a Win2K3 server and the printer is an HP815 shared off of it, and I am a domain admin and logged into my computer as such - if I go to the server, I can set the custom page size - is this a limitation of a shared printer, or is something else amiss?? SignatureMike Matheny > Hi Mike, > And you could not set a custom page size starting from the [quoted text clipped - 7 lines] >> that the programs are interoperable, I would think that this would be an >> 'interoperable' kind of option. Can you set up another printer definition for everyone that goes to the same printer. It is possible to print to a printer with or without page separators, and if it has PostScript a choice of PostScript or other -- so I think there are certainly ways around that. I never had anything to do with servers. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm > Well, the Custom button is grayed out, and the little Exclamation point says > that feature is not available because I don't have permission to save system [quoted text clipped - 15 lines] > >> that the programs are interoperable, I would think that this would be an > >> 'interoperable' kind of option.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.