[jaws-uk] Re: Excel query.
- From: David W Wood <g3yxx@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: jaws-uk@xxxxxxxxxxxxx
- Date: Tue, 7 Jun 2005 20:15:52 +0100
Robin
the first thing that you need is the 'autofit' function.
The way to do it is:
select all - ctrl+a
format - alt+o
cursor down to columns
tab across to autofit
press enter
your columns will be selected to the appropriate fit.
The difficulty with JAWS is that it will speak the entry irrespective of
whether or not it fits the visual presentation on screen.
You can then choose whether to print it in landscape or portrait.
I gather that somewhere in the print formatting is a facility to
proportion the text to the page, but this gives rise to cluttering and
difficulty of reading.
If you are printing to a laser printer and your touch is quite
sensitive, you can ascertain the print layout by feeling the toner on
the printed pages and ascertain the fit.
HTH
Another little fitting problem which sometimes occurs in Excel.
Is that If the result of a calculation is too wide for the selected
column width, then the result of
#######
may be presented to screen and JAWS.
choosing auto width as above should resolve this.
David
In message <B09AE9EEF29AB94BA1CED24B985F9255018475F7@xxxxxxxxxxxxxxx>,
Robin Clayden <r.clayden@xxxxxxxxx> writes
>Hi all,
>
>Using JFW 6.1, XP Pro.
>
>In Excel, I am attempting to make up a score chart for example, with a
>players name in column 1, various scores along the row for several
>columns etc.
>
>It may be tight to get what I want into the width of an A4 page, so is
>there a way that I can check that the width of some columns is just
>enough to take the text or number of digits I need to insert?
>
>For example, If Robin Clayden is the longest name being used, how do I
>find out what width of column will suffice for all players, so that all
>names are fully visible in the column? 3 digits will be the max used in
>any given column, but 888 takes up more width than 111 for example, so
>is there a magic trick to fix this?
>
>I fear this is a sighted help job, and not one for jfw.
>
>Kind regards,
>
>Robin Clayden, Switchboard.
>Edinburgh College of Art.
>** To leave the list, click on the immediately-following link:-
>** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subjectsubscribe]
>** If this link doesn't work then send a message to:
>** jaws-uk-request@xxxxxxxxxxxxx
>** and in the Subject line type
>** unsubscribe
>** For other list commands such as vacation mode, click on the
>** immediately-following link:-
>** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subjectúq]
>** or send a message, to
>** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** jaws-uk-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:jaws-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** jaws-uk-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
