[access-uk] Re: Excel problem
- From: "Peter Bentley" <bentleypdlists@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Sat, 20 Feb 2010 16:07:05 -0000
Carol, thanks for your input.
I do use JAWS.
Would it be a correct conclusion to assume that if JAWS reports no vertical
page breaks, then all the data fits into one page width? That does seem logical
even if it is not right.
Peter
----- Original Message -----
From: Carol Pearson
To: access-uk@xxxxxxxxxxxxx
Sent: Saturday, February 20, 2010 2:24 PM
Subject: [access-uk] Re: Excel problem
Peter/George:
George, I think Peter may be able to keep it simpler than this, that is, if
using Jaws. If you use Jaws Key (Insert) plus F1 whilst in the spread sheet
area you get some useful information as follows:
This is the spreadsheet area.
The worksheet name is Week 8 2010 and its number is 8.
Printable Pages Information:
no horizontal or vertical page breaks.
1 landscape page(s) can be printed from this worksheet.
Headers and Footers:
There are no headers or footers for this worksheet.
The region spans a 7 through g 16
visible range is F1 through J12
10 of the 60 visible cells contain data.
There are 8 worksheets in the Person Weekly Time Sheets 2010.xls workbook.
To move to a particular worksheet use Control+Shift+S.
Gridlines are on
Black Left Edge
Thin
Continuous
Black Top Edge
Thin
Continuous
Black Right Edge
Medium
Continuous
Black Bottom Edge
Thin
Continuous
The current settings file name is C:\Documents and Settings\CAROL
PEARSON\Application Data\Freedom
Scientific\JAWS\11.0\Settings\enu\PersonalizedSettings\excel_Person
Weekly Time Sheets 2010.xls.JSI.
List JAWS Hot Keys
Press ESCAPE to close this message.
If you go over the page boundary then (hopefully) it will be reported that 2
pages can be printed from that work sheet.
In addition, I find the Page Setup useful. On the Page tab you can "fit to".
I don't totally understand how much difference this makes to the size of the
print, so use carefully; but it does help me to fit to one page of a spread
sheet and people find it very acceptable.
Peter, I don't know if you're using Jaws so it may be not quite as helpful as
I'd hope, but I do trust it's of use!
--
Carol
carol.pearson29@xxxxxxxxxxxxxx
On Twitter: http://twitter.com/songbird49a
Ins+---- 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 4882 (20100220) __________
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:
