[jaws-uk] Re: Excel commands
- To: <jaws-uk@xxxxxxxxxxxxx>
- Date: Thu, 13 Nov 2008 08:42:46 -0000
Ah, that's the ticket, just what I needed. I can compact these sheets
down to a fraction of the size now, much easier to read and navigate
when you don't have all those empty areas.
Cheers, Robin
-----Original Message-----
From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx]
On Behalf Of Jamie Cuthbertson
Sent: 12 November 2008 21:13
To: jaws-uk@xxxxxxxxxxxxx
Subject: [jaws-uk] Re: Excel commands
Hi Robin,
If you don't want to have to read a row or column, what I tend to do is
to
use the command END followed by Up, Down Left or Right Arrow in whatever
direction you want to move.
For example, if you want to check for empty columns, go to the top row
and
move across to the right a column at a time. Each time you move across
press END followed by Down Arrow. If it goes all the way to row 65536,
then
you know it is blank. Then press END followed by Up Arrow to get back
to
the top of the column. Repeat the process as you move to the next
column.
If the focus goes to anywhere other than row 65536, it is not a blank
column.
Hope this helps.
Jamie
-----Original Message-----
From: jaws-uk-bounce@xxxxxxxxxxxxx [mailto:jaws-uk-bounce@xxxxxxxxxxxxx]
On
Behalf Of Robin Clayden
Sent: 12 November 2008 11:26
To: jaws-uk@xxxxxxxxxxxxx
Subject: [jaws-uk] Excel commands
Hi,
I've been given a file where the previous user has spaced out entries
and left loads of blank columns and rows just for visual presentation.
Is there an easy way to go down column A and scan or see if there is any
data in that row?
Or, can I arrow along a1, b1 etc and see if there are any empty columns?
It's a real pain the thought of having to go cell by cell to see where
he's put his figures...
Jfw10 Office suite 2003
Kind regards,
Robin Clayden, Telecoms
Edinburgh College of Art,
74 Lauriston Place,
EDINBURGH EH3 9DF.
T: +44 0 131 221 6000
E: r.clayden@xxxxxxxxx
W: http://www.eca.ac.uk
Edinburgh College of Art (eca) is a charity registered in Scotland,
number
SC009201
** 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
Edinburgh College of Art (eca) is a charity registered in Scotland, number
SC009201
** 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:
