Hello Robin,
There are no built-in Window-Eyes commands to read entire worksheet rows
and columns as this would not typically make much sense when spoken. One
place which is worth examining first is the very first row of the sheet.
This contains the column headers, and many times, more than one cell
will be merged so that the entire header can fit on the sheet and be
visually readable. Notice that Window-Eyes announces the range of the
merged cells. Most of the time, the data related to that header will be
under the first cell that is merged. So, for example, if the header took
over columns A through F, then the data associated to the header would
be under column A.
You can also review the screen with the mouse pointer, and the Virtual
View app accessed with Control-Alt-V may be another way to get a rough
idea of how the worksheet is visually laid out.
Regards,
Steve
On 6/13/2011 3:31 PM, [email protected] wrote:
HI Excel users.
I friend asked me a WE question I couldn't answer. In as much as I like
and use Excel, I've not really thought about doing what he's asking.
He's using Excel 2003 and he thinks WE 7.0 or 7.2
Is there a way in Excel to read the whole row or column at once, rather
than arrowing to each cell?
In general, how do you get a sense of the layout of a worksheet someone
else has given you, especially when you're not sure what cell the info
you may need will be in?
I typically build my own worksheets or they are a straight table, so
it's not often I need to figure out how things are laid out. This friend
is a construction project manager who is given budget worksheets and
other files.
Thanks.
*_____________________________*
*_Robin Van Lant_* <https://intraneta.keybank.com/wikey/User:Smithro>**
720-304-1060
Sr. Program Manager, _Strategic Services_
<https://intraneta.keybank.com/wikey/Strategic_Services>
Key Equipment Finance
Email Classification: KeyCorp Public
This communication may contain privileged and/or confidential
information. It is intended solely for the use of the addressee. If you
are not the intended recipient, you are strictly prohibited from
disclosing, copying, distributing or using any of this information. If
you received this communication in error, please contact the sender
immediately and destroy the material in its entirety, whether electronic
or hard copy. This communication may contain nonpublic personal
information about consumers subject to the restrictions of the
Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or
redisclose such information for any purpose other than to provide the
services for which you are receiving the information. 127 Public Square,
Cleveland, OH 44114
If you prefer not to receive future e-mail offers for products or
services from Key
send an e-mail to mailto:[email protected] with 'No Promotional
E-mails' in the
SUBJECT line.
--
Stephen Clower
Product support specialist
GW Micro, Inc. * 725 Airport North Office Park, Fort Wayne, IN 46825
260-489-3671 * gwmicro.com
If you reply to this message it will be delivered to the original sender only.
If your reply would benefit others on the list and your message is related to
GW Micro, then please consider sending your message to [email protected] so
the entire list will receive it.
GW-Info messages are archived at http://www.gwmicro.com/gwinfo. You can manage
your list subscription at http://www.gwmicro.com/listserv.
