[jaws-uk] Re: Labelling headings in Excel
- From: "Ankers, Dave (UK)" <Dave.Ankers@xxxxxxxxxxxxxx>
- To: <jaws-uk@xxxxxxxxxxxxx>
- Date: Wed, 5 Dec 2007 10:59:26 -0000
Jamie,
I have found the solution, move to the cell containing the heading,
press Alt+I for insert, N for name, D for define, the heading name will
be highlighted, add something to the end of it to indicate the worksheet
name if needed, then press enter to complete and then press control+S to
save To quickly navigate to the heading from anywhere in the workbook,
press F5 and tab once to enter the list of headings, and then either
arrow down or press the first letter of the heading, till the correct
one is selected and then press enter. That should take you straight to
the heading, from wherever you are in the workbook.
Hope that proves useful.
Dave
Dave,
Yes, I see what you mean but I'm afraid that I don't know how you would
do this.
Jamie
-----Original Message-----
From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx]
On Behalf Of Ankers, Dave (UK)
Sent: 03 December 2007 11:56
To: jaws-uk@xxxxxxxxxxxxx
Subject: [jaws-uk] Re: Labelling headings in Excel
Jamie,
If I could label individual headings, and call up and select from a
list, I could quickly navigate to a heading anywhere within a
spreadsheet and not just certain columns or rows.
Dave
Dave,
It certainly makes clearer what you would like to do but I'm afraid that
I don't know if this can be done or not. Are all your columns and rows
regular in layout or do you have merged cells? If they are regular, is
it not just as easy to use keyboard commands such as Control+UP/DOWN
ARROW or
Control+LEFT/RIGHT ARROW or HOME to get to the left column etc?
I tend to just remember the row where my headings are and then use the
"GoTo" command with Control+G to get to the relevant cell but this isn't
what you are looking for.
Sorry I can't help more.
Jamie
-----Original Message-----
From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx]
On Behalf Of Ankers, Dave (UK)
Sent: 30 November 2007 08:49
To: jaws-uk@xxxxxxxxxxxxx
Subject: [jaws-uk] Re: Labelling headings in Excel
Hi Jamie,
I have enabled column and row titles, so they read out when navigating
through the spreadsheet. What I would like to do is label the row
headings and as with web pages where on pressing insert+F6, a list
appears, from which the required heading can be picked, and taken
straight to it, thus vastly speeding up the process.
Hope that makes it clearer.
Cheers
Dave
Dave,
Can you give a little more clarification on what you want to be able to
do here. Do you want to be able to get to the headings or to have the
headings read out when you are moving along a row of data lower down in
the spread sheet?
Jamie
Hi All,
Can anyone help please. I have a spreadsheet with a number of headings
which I would like to find a fast way of navigating to. I thought there
was a way of labelling them and simply select from a list. But I have
been unable to find any tutorial for this. Any advice would be much
appreciated.
Cheers
Dave
********************************************************************
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.
********************************************************************
** 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
** 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
** 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
** 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
** 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:
