[access-uk] Re: Excelprinting problem
- From: "Peter Bentley" <bentleypdlists@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Sat, 20 Feb 2010 14:24:29 -0000
Thanks George. Although this does not provide the actual solution, at least I
have a clearer idea of what will happen in the eventuality of producing a table
which comprises too many columns to fit widthways on a single page.
Peter
----- Original Message -----
From: George Bell
To: access-uk@xxxxxxxxxxxxx
Sent: Saturday, February 20, 2010 1:06 PM
Subject: [access-uk] Re: Excel problem
Tricky one Peter, but here's one possible suggestion. All it will do though
is tell you if it requires one page or more though.
I'd suggest using a point size of 10 as that is generally acceptable for most
normally sighted people.
Once you have set up your spreadsheet and entered all data, autofit the
contents of rows and columns. This will hopefully ensure that all of the data
can be seen, and not truncated by a narrow column.
If you now go to the Print function. You will see there is an option to
select what pages you wish to print as well as a Print Preview Button.
You could begin by look at the print pages option and see if is says for
example "1-2".
The tricky bit is going to be to establish if that's two pages one after the
other meaning you have many rows - roughly speaking over 50 on a page. Or if
your data has too many columns and prints two sheet side by side.
George.
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of
Peter Bentley
Sent: 20 February 2010 12:44
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Excel problem
Using office 2000 but suspect the same principle would apply to any version.
Can anybody tell me how to check if an Excel table will fit on to a page with
ways. I realise that there is an "auto fit" function but this can squash text
to the extent that the figures become unreadable so it is not really the answer.
Any suggestions appreciated.
Peter Bentley
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4881 (20100219) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4881 (20100219) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4882 (20100220) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
Other related posts:
- » [access-uk] Re: Excelprinting problem - Peter Bentley
