Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

A3 "view" in Excel


  • Please log in to reply

#1
Leehaa

Leehaa

    Member

  • Member
  • PipPip
  • 40 posts
A client would like to be able to edit in Excel in "A3 format".

Ie: page breaks etc where they should be for an A3 spreadsheet...


Is this possible (when you don't have a printer that supports A3)? I didn't think it was, but the client insisted that she believes there is a way...

I understood that you have an A3 printer, you can automatically adjust the spreadsheet to fit this (via page set up), but if you don't, it's not possible... :whistling:

The client said that she was sending the document to her husband to print off. My understanding is that, as he has a printer that prints A3, he will be able to adjust excel to A3 in his paper set up, but my client won't be able to...

Please advise - i need to respond to the client asap!


Thanks,

Leah

Edited by Leehaa, 31 May 2006 - 04:50 AM.

  • 0

Advertisements


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
she should just be able to go to file > page setup > and change the page size to a3...irrespective of the printer's capabilities as the page setup dialog doesn't really have the printer settings in there...
  • 0

#3
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
and if not...she can set the document to tabloid (11X17) as it's pretty darned close to a3 (11.69 x 16.54)
  • 0

#4
dsm

dsm

    Member

  • Member
  • PipPip
  • 98 posts
dsenette,
Which version of excel are you using ?

I am using Excel 2003 and I can't replicate what you are suggesting.

In all cases that I have tested in the past the Paper Size in the Page Setup dialogue has been limited by the maximum capability of the selected printer.



Leehaa,
Despite what I have mentioned above I was able to find a way to setup in A3 with only an A4 printer attached.
I am using Windows XP Home and Office 2003.

I have 3 printer destinations available (only 1 physical printer)
>> Epson (A4 only) >> Fax >> Microsoft Office Document Image Writer

When the Microsoft Office Document Image Writer is selected the Paper Size dropdown allows selection of A3.

I am guessing this is the key to how your client managed this in the past.


Hope this helps
DSM
  • 0

#5
Leehaa

Leehaa

    Member

  • Topic Starter
  • Member
  • PipPip
  • 40 posts

dsenette,
Which version of excel are you using ?

I am using Excel 2003 and I can't replicate what you are suggesting.

In all cases that I have tested in the past the Paper Size in the Page Setup dialogue has been limited by the maximum capability of the selected printer.



Leehaa,
Despite what I have mentioned above I was able to find a way to setup in A3 with only an A4 printer attached.
I am using Windows XP Home and Office 2003.

I have 3 printer destinations available (only 1 physical printer)
>> Epson (A4 only) >> Fax >> Microsoft Office Document Image Writer

When the Microsoft Office Document Image Writer is selected the Paper Size dropdown allows selection of A3.

I am guessing this is the key to how your client managed this in the past.


Hope this helps
DSM


Yes I couldn't find the options either, and was using Excel 2003 on XP professional.

Excellent. I thought there must have been a reason for her believing that it can be done... she is a home - worker, using xp home with Excel 2003, but was in the office at the time. I'm not sure whether she has a printer at home, so could have well been on the Doocument image viewer when she'd tried in the past!!

Thanks guys - some useful info there!!

Leah
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP