[jaws-uk] Re: Merged cells in Excel
- From: Catherine Turner <catherineturner2007@xxxxxxxxxxxxxx>
- To: jaws-uk@xxxxxxxxxxxxx
- Date: Fri, 14 Oct 2011 09:06:59 +0100
Oh thank you everyone. Perhaps I should be confident that what I'm
hearing is all there is to hear. But it seems to behave strangely
e.g. I'll get onto a merged cell containing data, move up or down from
it, and then when I move back again there doesn't seem to be data
there. I'll get onto c47 which says merged cells c47 through n47,
cursor down and it puts me onto n48 instead of where I thought it
would put me c48. Then I try to bring up a list of what's in that
column, and there is no data in that column. Perhaps this is not
strange but what should happen, but I find it very difficult therefore
to try and find my way and around and understand a spreadsheet that
someone else has created with lots of merged cells in it. What is the
purpose of merging cells?
Does anyone have any particular approaches to getting an understanding
of other people's spreadsheets? I like to get a visual image in my
mind and find it very difficult when there are merged cells and I
can't cursor around as I thought I'd be able to. I must be taking the
wrong approach somehow...
Catherine
On 10/8/11, David W Wood (G3YXX) <david.g3yxx@xxxxxxxxxxxxxx> wrote:
> 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
>
>
--
Twitter: CTurner1980
My blog:
http://catherineturner.wordpress.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
Other related posts:
