[access-uk] Re: EXCEL QUESTIONS AGAIN

  • From: "Griffiths, Steve" <Steve.Griffiths@xxxxxxxxxxx>
  • To: <access-uk@xxxxxxxxxxxxx>
  • Date: Fri, 23 Apr 2010 13:13:47 +0100

Carol,

Question 3 sounds like your friend has used the Freeze feature to lock
column A onto the screen. This can be useful for sighted people because
if the row headings are in column A, they stay on screen no matter how
far you scroll to the right. The fact that when you press Ctrl+Home, you
go to cell B1 indicates she has frozen column A only.

To freeze rows and columns like this, move to the first cell below and
to the right of the rows and columns you want to keep on screen and
choose Freeze from the Window menu (in Excel 2007, choose Freeze Panes
from the View tab). So, to get the effect your friend has, focus on B1.
If you wanted to keep column A and rows 1 to 3 on screen, you'd go to
cell B4.

To unfreeze the sheet, use the same method - it's a toggle.

Steve

-----Original Message-----
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf
Of Carol Pearson
Sent: 21 April 2010 22:47
To: Access UK Mailing List
Subject: [access-uk] EXCEL QUESTIONS AGAIN

Hi all,

Well, I have more EXCEL questions, but these are different from the last
and, even if you know one and not all, a response would be welcome!

1    Is it possible to send EXCEL sheets (rather than the whole workbook
via 
Outlook Express.  I've read this is possible in Outlook but wonder if
anyone has found a way to do it in Outlook Express?

2    In a friend's workbook, which I now use regularly, I've noticed
that, 
when sorting on a column, that column is automatically spoken by Jaws
for me to choose.  However, I think this must be something she's built
in as I haven't achieved this on my own work sheets.  Anyone know how to
do it, please?  (She doesn't seem to have a clue what I mean when I ask
her, but it does work on her sheets and not mine!  <Smiles>)

3    With my friend's spread sheet, I also notice something different
and 
can't quite fathom it:  On my own sheets, CTRL+HOME (using Jaws) causes
me to be positioned at my first cell, IE, A1.  On her sheet, I then have
to press left arrow once in order to land at the same point, IE, her A1.
Has she just shifted cells left (perhaps to show more on screen)?  Even
if this is so, I can't reproduce it myself though, of course, can copy
it using her sheet.  If anyone knows what I'm waffling on about and how
to achieve it then I'd be most grateful to know.

4 - and finally    I love EXCEL and now have several sheets I use.  I
learn 
something with each new sheet but realise there's lots more I can still
learn.  Does anyone have any suggestions about good, straightforward
tutorials for visually impaired people (preferably using JAWS) that I'd
find useful?

Thanks for replies to any or all of these questions.

--
Carol
carol.pearson29@xxxxxxxxxxxxxx
On Twitter:  http://twitter.com/songbird49a


** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-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:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq



 To report this e-mail as Spam, please forward it to:
spam@xxxxxxxxxxxxxxx


-- 
DISCLAIMER:

NOTICE: The information contained in this email and any attachments is 
confidential and may be privileged.  If you are not the intended 
recipient you should not use, disclose, distribute or copy any of the 
content of it or of any attachment; you are requested to notify the 
sender immediately of your receipt of the email and then to delete it 
and any attachments from your system.

RNIB endeavours to ensure that emails and any attachments generated by
its staff are free from viruses or other contaminants.  However, it 
cannot accept any responsibility for any  such which are transmitted.
We therefore recommend you scan all attachments.

Please note that the statements and views expressed in this email and 
any attachments are those of the author and do not necessarily represent
those of RNIB.

RNIB Registered Charity Number: 226227

Website: http://www.rnib.org.uk



This message has been scanned for viruses by Websense Hosted Security - 
http://www.websense.com/content/HostedEmailSecurity.aspx

** To leave the list, click on the immediately-following link:-
** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** access-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:access-uk-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq

Other related posts: