[jaws-uk] Re: Merged cells in Excel
- From: "David W Wood \(G3YXX\)" <david.g3yxx@xxxxxxxxxxxxxx>
- To: <jaws-uk@xxxxxxxxxxxxx>
- Date: Sat, 8 Oct 2011 13:42:48 +0100
Also make sure that the column widths are sufficiently wide as follows:
Select all (control plus a)
Format (alt plus o)
Columns (c)
Autoformat (a)
David W Wood
Ham call - G3YXX
FOC # - 1685
Licensed - 1969
-----Original Message-----
From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx] On
Behalf Of Jamie Cuthbertson
Sent: Saturday, October 08, 2011 12:41 PM
To: jaws-uk@xxxxxxxxxxxxx
Subject: [jaws-uk] Re: Merged cells in Excel
Hi Catherine,
Normally Jaws will speak the contents of a block of merged cells in just the
same way as it would for a single cell. If you only get a little spoken
when you go onto this merged block, it is likely that there is only the
contents that you hear spoken.
As Jim says, you can read the contents by using F2, which is basically
putting you in an editing mode, or you can read the formula (if there is
one) by pressing Control+F2.
If a block of cells have been merged when there is data in cells throughout
the block, then the data in all the cells apart from the cell at the top
left of the block will be permanently deleted. You should be pretty
confident that the only contents that are in the merged area are the items
spoken by Jaws.
You could also try unmerging the cells and any content that was in the
merged area will end up in the top left cell of the merged block.
Jamie
-----Original Message-----
From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx] On
Behalf Of Catherine Turner
Sent: 08 October 2011 10:58
To: jaws-uk
Subject: [jaws-uk] Merged cells in Excel
Hi,
I'm looking at a spreadsheet someone else created in Excel 2003 using
JAWS 10. There are a lot of merged cells and I have the feeling I am
missing something. Is there any particular way to deal with merged
cells? JAWS just reads a small amount of content and says a huge
amount of cells are merged, and I'm not sure how to get at the rest of
the content in those cells.
Catherine
** 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
__________ Information from ESET Smart Security, version of virus signature
database 6525 (20111007) __________
The message was checked by ESET Smart Security.
http://www.eset.com
** 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
--
I am using the free version of SPAMfighter.
We are a community of 7 million users fighting spam.
SPAMfighter has removed 1920 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
The Professional version does not have this message
** 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:
