Ah, I get it now. Sneaky! Means the one column I see on this sheet is whether I have done or not done items! <Smiles>
Thanks Steve. -- Carol carol.pearson29@xxxxxxxxxxxxxx On Twitter: http://twitter.com/songbird49a ---- Original Message ---- From: "Griffiths, Steve" <Steve.Griffiths@xxxxxxxxxxx> To: <access-uk@xxxxxxxxxxxxx> Sent: Friday, April 23, 2010 1:13 PM Subject: [access-uk] Re: EXCEL QUESTIONS AGAIN
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
** 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