No! I want to make an appointment book that shows a week at a time with the flexibility of altering times and booking multiple appointments at same times if desired and to show a week at a time. The times and the days of the weeks freeze, no problem but the names and details need to shift under the days in groups of five so that when I shift to next week the entire week pane moves so Monday lines up under Monday.
There are a few strategies that might work I suppose just that I haven't fond one. For example it would be possible to calculate a number of columns to the left or right of the left most visible column, select that and bring it to the left most column position preferably to act with a keystroke for week left and week right I just can't find a way to do it and for some reason I can't get the Excel (or the Word for that matter) help system to work on this machine and I don't know why that is either. It does work better on my computer at work but not always and I don't really get much time for that sort of problem solving on-the-job without camping there. So, I do know how to freeze rows and columns. That isn't any good if they don't refer to the correct data. There must be a simple way to do this otherwise that would not work for any application. What purpose would a header of assets be when one scrolls liabilities under it? About as much use as a header of Friday with next Tuesday's data under it. Dale Leavens, Cochrane Ontario Canada [EMAIL PROTECTED] Skype DaleLeavens Come and meet Aurora, Nakita and Nanook at our polar bear habitat. ----- Original Message ----- From: "David Griffith" <[EMAIL PROTECTED]> To: <jaws-users-list@jaws-users.com> Sent: Sunday, September 30, 2007 5:31 AM Subject: Re: [JAWS-Users] Moving pane in Excel? > Are you talking about freeze titles? > You can freeze titles for a row and or a column. > > This will for a sighted user scroll a spreadsheet "under" the title rows and > columns keeping them in sight so that they can reference titles on large > spreadsheets. > > If this is what you want the commands are found on the menu bar under the > Window menu. There wil be option to freeze panes there and you can specify > the row and column. > > Regards > > David Griffith > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dale Leavens > Sent: 30 September 2007 05:45 > To: jaws-users-list@jaws-users.com > 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: <jaws-users-list@jaws-users.com> > 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: <jaws-users-list@jaws-users.com> >> 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: <jaws-users-list@jaws-users.com> >>> 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: <jaws-users-list@jaws-users.com> >>>> 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: <jaws-users-list@jaws-users.com> >>>>> 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/jaws-users-list@jaws-users.com >>>>>> To post to this group, send email to >>>>>> jaws-users-list@jaws-users.com >>>>>> 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/jaws-users-list@jaws-users.com >>>>> To post to this group, send email to >>>>> jaws-users-list@jaws-users.com >>>>> 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/jaws-users-list@jaws-users.com >>>> To post to this group, send email to >>>> jaws-users-list@jaws-users.com >>>> 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/jaws-users-list@jaws-users.com >>> To post to this group, send email to >>> jaws-users-list@jaws-users.com >>> 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/jaws-users-list@jaws-users.com >> To post to this group, send email to >> jaws-users-list@jaws-users.com >> 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/jaws-users-list@jaws-users.com >> To post to this group, send email to >> jaws-users-list@jaws-users.com >> 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/jaws-users-list@jaws-users.com > To post to this group, send email to > jaws-users-list@jaws-users.com > 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] > > > __________ NOD32 2560 (20070930) Information __________ > > This message was checked by NOD32 antivirus system. > http://www.eset.com > > > > > Visit the JAWS Users List home page at: > http://www.jaws-users.com > Address for the list archives: > http://www.mail-archive.com/jaws-users-list@jaws-users.com > To post to this group, send email to > jaws-users-list@jaws-users.com > 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/jaws-users-list@jaws-users.com To post to this group, send email to jaws-users-list@jaws-users.com 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]