Hi Annette, My mistake. Sorry about my error. Also, thank you, it will be easier using that command than the key sequence.
Take care. Brian Lee brianl...@charter.net -----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Annette Carr Sent: Saturday, October 16, 2010 4:43 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Copying Worksheets | Excel 2007 Brian, I am not referring to the Control+Shift+S command. There is an additional command in JAWS 11 for use in Excel 2007 that is Insert+Shift+S. There is a chance that it is Insert+Control+S, but I do not think so. As I said in my previous post, I cannot confirm the command until I get back to work . -----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Brian Lee Sent: Saturday, October 16, 2010 7:27 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Copying Worksheets | Excel 2007 Hello Bill and Annette, The CTRL+Shift+S command only lists the worksheets so you can move to one of them. In order to get the dialog box that Annette referred to you can use Alt, followed by H, followed by O, followed by M. I am using Excel 2010 but I am quite sure the key sequence was the same in Excel 2007. You can also route JAWS cursor, do a page down, use up arrow to the area where the sheets are listed and use the JAWS cursor to simulate a right mouse button click on the name of the sheet to be moved. The Move or Copy Sheet menu choice will be in the context menu. In the list of worksheets in the dialog box, you want to pick the sheet before which you want the one you are moving to be located. The last choice in the list is to move your worksheet to the end of the sheets in the workbook. You can also check the box to make a copy as Annette mentioned. Take care. Brian Lee brianl...@charter.net -----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Annette Carr Sent: Saturday, October 16, 2010 3:52 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Copying Worksheets | Excel 2007 In Excel 2007, I believe that the command is Insert+Shift+S. Here at home I have 2003 running on a laptop, And at work I use the command all of the time on a full 101 keyboard, so I can't confirm it. If this is not the correct command, look in Insert+F1, Insert+H, or Insert+w. I know I found it in one of these informational screens. Here is how to use it. When you are in the worksheet you want to copy, use the Insert+Shift+s command to bring up a menu. Arrow down to Copy/Move sheet and press Enter. A dialog box will come up that we are all used to from Excel 2003. This dialog box will allow you to select where you want to copy or move the sheet to (i.e. same file, blank file, some other file, etc.). You can select where among all of the other sheets in the workbook you want the sheet to be placed, and then there is a check box that you check if you want to make a copy of the sheet, or leave it unchecked if you want to move the sheet. Use this same command to rename your current worksheet. Let me give you a heads up about a problem I've had with using the Insert+Shift+s command. It appears that when I have data in A1, this command does not work correctly. When this happens, you have to move your cursor down to beyond the last row of data and it will work again. As long as you do not go back to row 1 the command will continue working. I have talked to FS support about this issue, and I am working on sending them a sample file where this problem occurs. Because the file I am using at work has PIP data in it, I am having to create a new file to send to FS to work with. HTH, Annette -----Original Message----- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Bill Tipton Sent: Saturday, October 16, 2010 11:38 AM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Copying Worksheets | Excel 2007 Hello, How do you copy complete work sheets (with data) to a new Worksheet in same spreadsheet in Excel 2007, with JAWS 11? After I copy the worksheet; how do I rename the worksheet so I do not have duplicate worksheet names? Thank you, Bill For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ __________ Information from ESET Smart Security, version of virus signature database 5536 (20101016) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 5537 (20101016) __________ The message was checked by ESET Smart Security. http://www.eset.com For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ __________ Information from ESET Smart Security, version of virus signature database 5538 (20101016) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 5538 (20101016) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 5538 (20101016) __________ The message was checked by ESET Smart Security. http://www.eset.com For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
