Hi, May be You can use Excel goto command, ctrl+g. ctrl+g, a1 - go to cell a1 ctrl+g, a1:g100 - select cells from a1 to g100 ctrl+g, move with tab key to special button, spacebar, select with arrow keys what you need, for example Visible cells = select visible cells. May be you can use alt+page up or alt+ page down (move one screen left or right) or page up or page down - move one screen up or down.
hth Artur ctrl+g, ----- Original Message ----- From: "Dale Leavens" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, September 30, 2007 7:45 AM Subject: Re: [JAWS-Users] Moving pane in Excel? > Thanks, > > This information has been helpful but it isn't the answer I am looking > for. I like the naming though and I didn't know about it before now. > > I am looking for some way of calculating regions and highlighting them > then shifting them under the days of the week using a macro. This isn't > working well either, I am pretty sure I can select a block but don't know > how to make the left edge of it move to the edge of the visible screen. > > I don't understand pivot tables very well, maybe there is a way through > that channel. > > > Dale Leavens, Cochrane Ontario Canada > [EMAIL PROTECTED] > Skype DaleLeavens > Come and meet Aurora, Nakita and Nanook at our polar bear habitat. > > > ----- Original Message ----- > From: "KURTIS POTTER" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, September 25, 2007 7:47 AM > Subject: Re: [JAWS-Users] Moving pane in Excel? > > >> What I think you want is for the Row and Column titles to stay fixed on >> the screen so that no matter how far left or right you scroll this >> information is visible (at least for sighted users). If that is what >> you want it can be done in Excel, I used to do this when I was sighted, >> but I used the mouse to do it and haven't found the proper menu option >> yet. But I am still looking. >> If on the other hand, you do not care if the information is visible or >> not, but you want JAWS to speak the Row and Column titles then do this: >> 1 Place your cursor to the left of the first Column title and above the >> first Row Column. So if your Column titles began in B1 and Row Titles >> in A2 your cursor should be in A1. >> 2 Press alt I for the insert menu. >> 2 Press N for Name. >> 3 Press D for Define. (this should open a dialog box and put you in an >> edit field). >> 4 type "Title" (be sure the T is capital). >> 5 Press Enter. >> >> Now when you arrow left or right JAWS should say the column title and >> when you arrow up and down JAWS should say the ROW title. Be sure to >> save the file after doing this as this information is stored in excel. >> >> I hope this works for you. I will keep looking for the way to do this >> visually. I know it is out there. >> Let me know if you have any questions. >> >> >>>>> [EMAIL PROTECTED] 09/24/2007 7:56 PM >>> >> I don't know for sure that it can! >> >> It might be that I have to do it with V B A or possibly by recording a >> macro then modifying it to respond to some selected key strokes.. >> >> Dale Leavens, Cochrane Ontario Canada >> [EMAIL PROTECTED] >> Skype DaleLeavens >> Come and meet Aurora, Nakita and Nanook at our polar bear habitat. >> >> >> ----- Original Message ----- >> From: "Patricia" <[EMAIL PROTECTED]> >> To: <[email protected]> >> Sent: Monday, September 24, 2007 8:04 PM >> Subject: Re: [JAWS-Users] Moving pane in Excel? >> >> >>> Wow, didn't know Excel could do that... >>> >>> ----- Original Message ----- >>> From: "Dale Leavens" <[EMAIL PROTECTED]> >>> To: <[email protected]> >>> Sent: Monday, September 24, 2007 6:54 PM >>> Subject: Re: [JAWS-Users] Moving pane in Excel? >>> >>> >>>> No, I want to scroll the displayed sells a fixed number of positions >> left >>>> or right. Imagine a roll of paper with a week of dates showing >> through a >>>> square. You roll the strip one increment and the next series shows >> through >>>> the window. >>>> >>>> Dale Leavens, Cochrane Ontario Canada >>>> [EMAIL PROTECTED] >>>> Skype DaleLeavens >>>> Come and meet Aurora, Nakita and Nanook at our polar bear habitat. >>>> >>>> >>>> ----- Original Message ----- >>>> From: "Patricia" <[EMAIL PROTECTED]> >>>> To: <[email protected]> >>>> Sent: Monday, September 24, 2007 7:42 PM >>>> Subject: Re: [JAWS-Users] Moving pane in Excel? >>>> >>>> >>>>> Are you wanting to copy and paste rows and columns somewhere else >> in >>>>> excel? >>>>> >>>>> If so, the shift-spacebar is the copy command for a row and >>>>> control-spacebar >>>>> is the copy for a column. >>>>> you also can hold down the shift key like with your left hand and >> use the >>>>> right/left arrow keys to select blocks of text to move elsewhere as >> well. >>>>> One thing to note...if you use any kind of dollars/cents which you >> can >>>>> copy >>>>> and paste into anotehr cell, it tends to show as ### sign to get >> your >>>>> copied >>>>> info to show up just widen your cell... >>>>> >>>>> Patricia >>>>> ----- Original Message ----- >>>>> From: "Dale Leavens" <[EMAIL PROTECTED]> >>>>> To: <[email protected]> >>>>> Sent: Monday, September 24, 2007 6:09 PM >>>>> Subject: [JAWS-Users] Moving pane in Excel? >>>>> >>>>> >>>>>> There seems to be something wrong with the help system for MS >> Office on >>>>>> this computer making me really struggle to figure things out. >> Maybe this >>>>>> cannot be done but hopefully it can and someone knows how. >>>>>> >>>>>> In Excel 2000 I want to keep the top column titles fixed and the >> left >>>>>> row >>>>>> titles fixed. I seem to have figured that out but now I want to >> move the >>>>>> adjacent block left and right by a fixed number of cells. >>>>>> >>>>>> What I am trying to make happen is a list of times down the left >> side >>>>>> and >>>>>> days across the top and with a keystroke or mouse dropping get >> the day >>>>>> information to shift left and right one week at a time. >>>>>> >>>>>> If anyone knows that this can be done I will struggle with the >> help to >>>>>> find it. better still a description of how would be really nice. >>>>>> >>>>>> All I seem to be able to get out of the Help system is the intro >> page >>>>>> about how to get help from the Office Assistant and so on, nothing >> seems >>>>>> to persuade this machine to give up that answer wizard which lets >> you >>>>>> type >>>>>> in a question. It does work a little better some of the time on >> the >>>>>> computer at work but I don't have time to play with these ideas >> there. >>>>>> >>>>>> Apologies if this question is sailing a little close to the edge >> of "on >>>>>> topic" for this list, I appreciate it to be an arguable point. >>>>>> >>>>>> Dale Leavens, Cochrane Ontario Canada >>>>>> [EMAIL PROTECTED] >>>>>> Skype DaleLeavens >>>>>> Come and meet Aurora, Nakita and Nanook at our polar bear >> habitat. >>>>>> >>>>>> Visit the JAWS Users List home page at: >>>>>> http://www.jaws-users.com >>>>>> Address for the list archives: >>>>>> http://www.mail-archive.com/[email protected] >>>>>> To post to this group, send email to >>>>>> [email protected] >>>>>> To unsubscribe from this group, send an email to >>>>>> [EMAIL PROTECTED] >>>>>> For help from Mailman with your account Put the word help in the >> subject >>>>>> or body of a blank message to: >>>>>> [EMAIL PROTECTED] >>>>>> Use the following form in order to contact the management team >>>>>> http://www.jaws-users.com/managers.php >>>>>> If you wish to join the Blind Computing list send a blank email to >> the >>>>>> following address: >>>>>> [EMAIL PROTECTED] >>>>> >>>>> >>>>> Visit the JAWS Users List home page at: >>>>> http://www.jaws-users.com >>>>> Address for the list archives: >>>>> http://www.mail-archive.com/[email protected] >>>>> To post to this group, send email to >>>>> [email protected] >>>>> To unsubscribe from this group, send an email to >>>>> [EMAIL PROTECTED] >>>>> For help from Mailman with your account Put the word help in the >> subject >>>>> or body of a blank message to: >>>>> [EMAIL PROTECTED] >>>>> Use the following form in order to contact the management team >>>>> http://www.jaws-users.com/managers.php >>>>> If you wish to join the Blind Computing list send a blank email to >> the >>>>> following address: >>>>> [EMAIL PROTECTED] >>>>> >>>> >>>> Visit the JAWS Users List home page at: >>>> http://www.jaws-users.com >>>> Address for the list archives: >>>> http://www.mail-archive.com/[email protected] >>>> To post to this group, send email to >>>> [email protected] >>>> To unsubscribe from this group, send an email to >>>> [EMAIL PROTECTED] >>>> For help from Mailman with your account Put the word help in the >> subject >>>> or body of a blank message to: >>>> [EMAIL PROTECTED] >>>> Use the following form in order to contact the management team >>>> http://www.jaws-users.com/managers.php >>>> If you wish to join the Blind Computing list send a blank email to >> the >>>> following address: >>>> [EMAIL PROTECTED] >>> >>> >>> Visit the JAWS Users List home page at: >>> http://www.jaws-users.com >>> Address for the list archives: >>> http://www.mail-archive.com/[email protected] >>> To post to this group, send email to >>> [email protected] >>> To unsubscribe from this group, send an email to >>> [EMAIL PROTECTED] >>> For help from Mailman with your account Put the word help in the >> subject or body of a blank message to: >>> [EMAIL PROTECTED] >>> Use the following form in order to contact the management team >>> http://www.jaws-users.com/managers.php >>> If you wish to join the Blind Computing list send a blank email to >> the following address: >>> [EMAIL PROTECTED] >>> >> >> Visit the JAWS Users List home page at: >> http://www.jaws-users.com >> Address for the list archives: >> http://www.mail-archive.com/[email protected] >> To post to this group, send email to >> [email protected] >> To unsubscribe from this group, send an email to >> [EMAIL PROTECTED] >> For help from Mailman with your account Put the word help in the >> subject or body of a blank message to: >> [EMAIL PROTECTED] >> Use the following form in order to contact the management team >> http://www.jaws-users.com/managers.php >> If you wish to join the Blind Computing list send a blank email to the >> following address: >> [EMAIL PROTECTED] >> >> Visit the JAWS Users List home page at: >> http://www.jaws-users.com >> Address for the list archives: >> http://www.mail-archive.com/[email protected] >> To post to this group, send email to >> [email protected] >> To unsubscribe from this group, send an email to >> [EMAIL PROTECTED] >> For help from Mailman with your account Put the word help in the subject >> or body of a blank message to: >> [EMAIL PROTECTED] >> Use the following form in order to contact the management team >> http://www.jaws-users.com/managers.php >> If you wish to join the Blind Computing list send a blank email to the >> following address: >> [EMAIL PROTECTED] >> > > Visit the JAWS Users List home page at: > http://www.jaws-users.com > Address for the list archives: > http://www.mail-archive.com/[email protected] > To post to this group, send email to > [email protected] > To unsubscribe from this group, send an email to > [EMAIL PROTECTED] > For help from Mailman with your account Put the word help in the subject > or body of a blank message to: > [EMAIL PROTECTED] > Use the following form in order to contact the management team > http://www.jaws-users.com/managers.php > If you wish to join the Blind Computing list send a blank email to the > following address: > [EMAIL PROTECTED] > > Visit the JAWS Users List home page at: http://www.jaws-users.com Address for the list archives: http://www.mail-archive.com/[email protected] To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/managers.php If you wish to join the Blind Computing list send a blank email to the following address: [EMAIL PROTECTED]
