Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
Annette, It works fine as stated below in JAWS 13 Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Annette Carr Sent: Friday, December 02, 2011 8:07 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 I have not installed JAWS 13, so I did not know that it was not available. I am using JAWS 12 and have found that command very helpful. I will not be happy if it is no longer available. Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Thursday, December 01, 2011 8:50 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, For some reason insert plus shift plus s brings up the system menu in Excel 2010 using JAWS13. It will not bring up that menu you mentioned. I have noticed that a lot of Office commands don't work like they use to with JAWS13. Ihad to route jaws to pc, do a control end, find the name of the sheet, and do a right click on it to get the menu you described. Thats the way Don mentioned how to do it in his post. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 9:36 PM, Annette Carr wrote: To have a copy of the worksheet put in the same workbook or a different one: 1. Open the workbook where the original worksheet is. 2. If you are wanting to put the copy of the original worksheet into an existing workbook, open that file. If you are just making a copy of the sheet inside the file where it already exists, or if you want to put it in a new workbook, skip this step. 3. Use Insert+Shift+s to bring up a context menu. 4. Arrow down to copy/move worksheet and press Enter. 5. A dialog box comes up with 3 things that you need to deal with. 5.1 Where do you want the sheet to go? Same workbook, a new workbook or another existing workbook. This is a combo box. 5.2 Where do you want the sheet to be placed in the workbook, Before...? This a list box. 5.3. Are you moving the sheet, or making a copy. If making a copy be sure to put a check in the check box. If you are copying the sheet in the workbook where it already exists, the name of the new worksheet will have a 2 added to its name. If you want to rename this sheet, use the Insert+Shift+s context menu again and arrow to Rename. HTH, Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 8:33 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, What I want to do is to take a worksheet copy all the data, including formulas, and paste it into a new worksheet. Iwant to take some spreadsheets I have recieved for doing certain statistical calculations. This way I can group the different sheets into workbooks so that I don't have so many single worksheets to open for tests and the like for my stats class. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 5:34 PM, Alan Robbins wrote: Greg, Could you be more specific as to what you want to do? I can help with either of the following: Do you want to select all data on a worksheet and paste into a new worksheet in the same book? Or, do you want to select an entire worksheet and move or copy to a new book? Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 3:59 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. -- Yesterday is forever gone, tomorrow may never come, today is the day of all days. 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/ 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/ 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/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
Hello, I am having problems getting it to work in JAWS13. This is what I have found. If your worksheets have all been named something else besides sheet 1 etc... insert plus shift plus s brings up the system menu, just as if you pressed alt plus space. However if you have at least one sheet with the default name, sheet 1, the insert plus shift plus s works as expected. As an example, I have a workbook I created with three sheets. the sheets are named binomial, geometric, and poisson. If I hit the insert plus shift plus s it just brings up the system menu. However, if I add a sheet to it and then use the command, it works just fine. I am using JAWS13 and Excel 2010. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 12/3/2011 8:48 AM, Alan Robbins wrote: Annette, It works fine as stated below in JAWS 13 Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Annette Carr Sent: Friday, December 02, 2011 8:07 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 I have not installed JAWS 13, so I did not know that it was not available. I am using JAWS 12 and have found that command very helpful. I will not be happy if it is no longer available. Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Thursday, December 01, 2011 8:50 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, For some reason insert plus shift plus s brings up the system menu in Excel 2010 using JAWS13. It will not bring up that menu you mentioned. I have noticed that a lot of Office commands don't work like they use to with JAWS13. Ihad to route jaws to pc, do a control end, find the name of the sheet, and do a right click on it to get the menu you described. Thats the way Don mentioned how to do it in his post. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 9:36 PM, Annette Carr wrote: To have a copy of the worksheet put in the same workbook or a different one: 1. Open the workbook where the original worksheet is. 2. If you are wanting to put the copy of the original worksheet into an existing workbook, open that file. If you are just making a copy of the sheet inside the file where it already exists, or if you want to put it in a new workbook, skip this step. 3. Use Insert+Shift+s to bring up a context menu. 4. Arrow down to copy/move worksheet and press Enter. 5. A dialog box comes up with 3 things that you need to deal with. 5.1 Where do you want the sheet to go? Same workbook, a new workbook or another existing workbook. This is a combo box. 5.2 Where do you want the sheet to be placed in the workbook, Before...? This a list box. 5.3. Are you moving the sheet, or making a copy. If making a copy be sure to put a check in the check box. If you are copying the sheet in the workbook where it already exists, the name of the new worksheet will have a 2 added to its name. If you want to rename this sheet, use the Insert+Shift+s context menu again and arrow to Rename. HTH, Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 8:33 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, What I want to do is to take a worksheet copy all the data, including formulas, and paste it into a new worksheet. Iwant to take some spreadsheets I have recieved for doing certain statistical calculations. This way I can group the different sheets into workbooks so that I don't have so many single worksheets to open for tests and the like for my stats class. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 5:34 PM, Alan Robbins wrote: Greg, Could you be more specific as to what you want to do? I can help with either of the following: Do you want to select all data on a worksheet and paste into a new worksheet in the same book? Or, do you want to select an entire worksheet and move or copy to a new book? Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 3:59 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. -- Yesterday is forever gone, tomorrow may never come, today is the day of all days
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
Greg, I get the proper menu with both of your examples below. I'm using Win XP Pro, Office 2010, and latest JAWS 13. Not sure why your system is behaving this way Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Saturday, December 03, 2011 1:39 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, I am having problems getting it to work in JAWS13. This is what I have found. If your worksheets have all been named something else besides sheet 1 etc... insert plus shift plus s brings up the system menu, just as if you pressed alt plus space. However if you have at least one sheet with the default name, sheet 1, the insert plus shift plus s works as expected. As an example, I have a workbook I created with three sheets. the sheets are named binomial, geometric, and poisson. If I hit the insert plus shift plus s it just brings up the system menu. However, if I add a sheet to it and then use the command, it works just fine. I am using JAWS13 and Excel 2010. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 12/3/2011 8:48 AM, Alan Robbins wrote: Annette, It works fine as stated below in JAWS 13 Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Annette Carr Sent: Friday, December 02, 2011 8:07 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 I have not installed JAWS 13, so I did not know that it was not available. I am using JAWS 12 and have found that command very helpful. I will not be happy if it is no longer available. Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Thursday, December 01, 2011 8:50 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, For some reason insert plus shift plus s brings up the system menu in Excel 2010 using JAWS13. It will not bring up that menu you mentioned. I have noticed that a lot of Office commands don't work like they use to with JAWS13. Ihad to route jaws to pc, do a control end, find the name of the sheet, and do a right click on it to get the menu you described. Thats the way Don mentioned how to do it in his post. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 9:36 PM, Annette Carr wrote: To have a copy of the worksheet put in the same workbook or a different one: 1. Open the workbook where the original worksheet is. 2. If you are wanting to put the copy of the original worksheet into an existing workbook, open that file. If you are just making a copy of the sheet inside the file where it already exists, or if you want to put it in a new workbook, skip this step. 3. Use Insert+Shift+s to bring up a context menu. 4. Arrow down to copy/move worksheet and press Enter. 5. A dialog box comes up with 3 things that you need to deal with. 5.1 Where do you want the sheet to go? Same workbook, a new workbook or another existing workbook. This is a combo box. 5.2 Where do you want the sheet to be placed in the workbook, Before...? This a list box. 5.3. Are you moving the sheet, or making a copy. If making a copy be sure to put a check in the check box. If you are copying the sheet in the workbook where it already exists, the name of the new worksheet will have a 2 added to its name. If you want to rename this sheet, use the Insert+Shift+s context menu again and arrow to Rename. HTH, Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 8:33 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, What I want to do is to take a worksheet copy all the data, including formulas, and paste it into a new worksheet. Iwant to take some spreadsheets I have recieved for doing certain statistical calculations. This way I can group the different sheets into workbooks so that I don't have so many single worksheets to open for tests and the like for my stats class. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 5:34 PM, Alan Robbins wrote: Greg, Could you be more specific as to what you want to do? I can help with either of the following: Do you want to select all data on a worksheet and paste into a new worksheet in the same book? Or, do you want to select an entire worksheet and move or copy to a new book
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
This may have some relevance. The other day I discovered that the insert+shift+s would not work on a sheet that was not maximized. Once I maximized, the command worked. Jerry Berrier, Access Technology Consultant 18 Trunfio Ln Everett, MA 02149 (508) 735-4420 je...@birdblind.org http://www.birdblind.org -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Alan Robbins Sent: Saturday, December 03, 2011 4:49 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Greg, I get the proper menu with both of your examples below. I'm using Win XP Pro, Office 2010, and latest JAWS 13. Not sure why your system is behaving this way Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Saturday, December 03, 2011 1:39 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, I am having problems getting it to work in JAWS13. This is what I have found. If your worksheets have all been named something else besides sheet 1 etc... insert plus shift plus s brings up the system menu, just as if you pressed alt plus space. However if you have at least one sheet with the default name, sheet 1, the insert plus shift plus s works as expected. As an example, I have a workbook I created with three sheets. the sheets are named binomial, geometric, and poisson. If I hit the insert plus shift plus s it just brings up the system menu. However, if I add a sheet to it and then use the command, it works just fine. I am using JAWS13 and Excel 2010. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 12/3/2011 8:48 AM, Alan Robbins wrote: Annette, It works fine as stated below in JAWS 13 Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Annette Carr Sent: Friday, December 02, 2011 8:07 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 I have not installed JAWS 13, so I did not know that it was not available. I am using JAWS 12 and have found that command very helpful. I will not be happy if it is no longer available. Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Thursday, December 01, 2011 8:50 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, For some reason insert plus shift plus s brings up the system menu in Excel 2010 using JAWS13. It will not bring up that menu you mentioned. I have noticed that a lot of Office commands don't work like they use to with JAWS13. Ihad to route jaws to pc, do a control end, find the name of the sheet, and do a right click on it to get the menu you described. Thats the way Don mentioned how to do it in his post. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 9:36 PM, Annette Carr wrote: To have a copy of the worksheet put in the same workbook or a different one: 1. Open the workbook where the original worksheet is. 2. If you are wanting to put the copy of the original worksheet into an existing workbook, open that file. If you are just making a copy of the sheet inside the file where it already exists, or if you want to put it in a new workbook, skip this step. 3. Use Insert+Shift+s to bring up a context menu. 4. Arrow down to copy/move worksheet and press Enter. 5. A dialog box comes up with 3 things that you need to deal with. 5.1 Where do you want the sheet to go? Same workbook, a new workbook or another existing workbook. This is a combo box. 5.2 Where do you want the sheet to be placed in the workbook, Before...? This a list box. 5.3. Are you moving the sheet, or making a copy. If making a copy be sure to put a check in the check box. If you are copying the sheet in the workbook where it already exists, the name of the new worksheet will have a 2 added to its name. If you want to rename this sheet, use the Insert+Shift+s context menu again and arrow to Rename. HTH, Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 8:33 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, What I want to do is to take a worksheet copy all the data, including formulas, and paste it into a new worksheet. Iwant to take some spreadsheets I have recieved for doing certain statistical
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
Hello, For some reason insert plus shift plus s brings up the system menu in Excel 2010 using JAWS13. It will not bring up that menu you mentioned. I have noticed that a lot of Office commands don't work like they use to with JAWS13. Ihad to route jaws to pc, do a control end, find the name of the sheet, and do a right click on it to get the menu you described. Thats the way Don mentioned how to do it in his post. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 9:36 PM, Annette Carr wrote: To have a copy of the worksheet put in the same workbook or a different one: 1. Open the workbook where the original worksheet is. 2. If you are wanting to put the copy of the original worksheet into an existing workbook, open that file. If you are just making a copy of the sheet inside the file where it already exists, or if you want to put it in a new workbook, skip this step. 3. Use Insert+Shift+s to bring up a context menu. 4. Arrow down to copy/move worksheet and press Enter. 5. A dialog box comes up with 3 things that you need to deal with. 5.1 Where do you want the sheet to go? Same workbook, a new workbook or another existing workbook. This is a combo box. 5.2 Where do you want the sheet to be placed in the workbook, Before...? This a list box. 5.3. Are you moving the sheet, or making a copy. If making a copy be sure to put a check in the check box. If you are copying the sheet in the workbook where it already exists, the name of the new worksheet will have a 2 added to its name. If you want to rename this sheet, use the Insert+Shift+s context menu again and arrow to Rename. HTH, Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 8:33 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, What I want to do is to take a worksheet copy all the data, including formulas, and paste it into a new worksheet. Iwant to take some spreadsheets I have recieved for doing certain statistical calculations. This way I can group the different sheets into workbooks so that I don't have so many single worksheets to open for tests and the like for my stats class. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 5:34 PM, Alan Robbins wrote: Greg, Could you be more specific as to what you want to do? I can help with either of the following: Do you want to select all data on a worksheet and paste into a new worksheet in the same book? Or, do you want to select an entire worksheet and move or copy to a new book? Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 3:59 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. -- Yesterday is forever gone, tomorrow may never come, today is the day of all days. 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/ 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/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
Annette, Thanks for this tip. Been looking for that since migrating from Excel 2000. I had figured out exactly what Don had been doing and it works but this quick keystroke gets you to the same dialogue box. Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Annette Carr Sent: Wednesday, November 30, 2011 9:39 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Don, Try using Insert+Shift+s to do things to your worksheets. Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Don Marang Sent: Wednesday, November 30, 2011 5:36 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 To select all cells in a worksheet, simply press Control + a. Then you can Press Control +c to copy and go to the next worksheet using Control + PageDown. Finally paste all of the cells with Control + v. It may be easier to move or copy the worksheet, rename the sheet, or other worksheet manipulation rather than cutting and pasting. The worksheet names are located at the bottom of the window. By default, they are simply named sheet 1, sheet 2, sheet 3, and so on. There probably is a better way to do this, but I turn on the JAWS Cursor with the NumPad minus (-). Then press PageDown to get to the bottom of the window. Find the sheet name that you want to manipulate by using the Control +Right Arrow keys several times. Now simulate a right mouse click with the NumPad star (*) keys. This will bring up a context menu of actions you can take on that sheet. *Don Marang* Vinux Software Development Coordinator - vinuxproject.org http://www.vinuxproject.org/ There is just so much stuff in the world that, to me, is devoid of any real substance, value, and content that I just try to make sure that I am working on things that matter. -- Dean Kamen On 11/30/2011 3:59 PM, Icewolf wrote: Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. 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/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
Hello, Now this is weird. If a workbook only has one sheet, the insert plus shift plus s brings up the system menu. However, if a workbook has multiple sheets, that command brings up the menu with the different options for the workbook. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 12/1/2011 8:49 AM, Icewolf wrote: Hello, For some reason insert plus shift plus s brings up the system menu in Excel 2010 using JAWS13. It will not bring up that menu you mentioned. I have noticed that a lot of Office commands don't work like they use to with JAWS13. Ihad to route jaws to pc, do a control end, find the name of the sheet, and do a right click on it to get the menu you described. Thats the way Don mentioned how to do it in his post. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 9:36 PM, Annette Carr wrote: To have a copy of the worksheet put in the same workbook or a different one: 1. Open the workbook where the original worksheet is. 2. If you are wanting to put the copy of the original worksheet into an existing workbook, open that file. If you are just making a copy of the sheet inside the file where it already exists, or if you want to put it in a new workbook, skip this step. 3. Use Insert+Shift+s to bring up a context menu. 4. Arrow down to copy/move worksheet and press Enter. 5. A dialog box comes up with 3 things that you need to deal with. 5.1 Where do you want the sheet to go? Same workbook, a new workbook or another existing workbook. This is a combo box. 5.2 Where do you want the sheet to be placed in the workbook, Before...? This a list box. 5.3. Are you moving the sheet, or making a copy. If making a copy be sure to put a check in the check box. If you are copying the sheet in the workbook where it already exists, the name of the new worksheet will have a 2 added to its name. If you want to rename this sheet, use the Insert+Shift+s context menu again and arrow to Rename. HTH, Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 8:33 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, What I want to do is to take a worksheet copy all the data, including formulas, and paste it into a new worksheet. Iwant to take some spreadsheets I have recieved for doing certain statistical calculations. This way I can group the different sheets into workbooks so that I don't have so many single worksheets to open for tests and the like for my stats class. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 5:34 PM, Alan Robbins wrote: Greg, Could you be more specific as to what you want to do? I can help with either of the following: Do you want to select all data on a worksheet and paste into a new worksheet in the same book? Or, do you want to select an entire worksheet and move or copy to a new book? Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 3:59 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. -- Yesterday is forever gone, tomorrow may never come, today is the day of all days. 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/ 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/ 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/
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
Greg, If it brings up the menu, down arrow until you hear move/copy and select that. This will get you to the dialogue box you want Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Thursday, December 01, 2011 9:04 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, Now this is weird. If a workbook only has one sheet, the insert plus shift plus s brings up the system menu. However, if a workbook has multiple sheets, that command brings up the menu with the different options for the workbook. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 12/1/2011 8:49 AM, Icewolf wrote: Hello, For some reason insert plus shift plus s brings up the system menu in Excel 2010 using JAWS13. It will not bring up that menu you mentioned. I have noticed that a lot of Office commands don't work like they use to with JAWS13. Ihad to route jaws to pc, do a control end, find the name of the sheet, and do a right click on it to get the menu you described. Thats the way Don mentioned how to do it in his post. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 9:36 PM, Annette Carr wrote: To have a copy of the worksheet put in the same workbook or a different one: 1. Open the workbook where the original worksheet is. 2. If you are wanting to put the copy of the original worksheet into an existing workbook, open that file. If you are just making a copy of the sheet inside the file where it already exists, or if you want to put it in a new workbook, skip this step. 3. Use Insert+Shift+s to bring up a context menu. 4. Arrow down to copy/move worksheet and press Enter. 5. A dialog box comes up with 3 things that you need to deal with. 5.1 Where do you want the sheet to go? Same workbook, a new workbook or another existing workbook. This is a combo box. 5.2 Where do you want the sheet to be placed in the workbook, Before...? This a list box. 5.3. Are you moving the sheet, or making a copy. If making a copy be sure to put a check in the check box. If you are copying the sheet in the workbook where it already exists, the name of the new worksheet will have a 2 added to its name. If you want to rename this sheet, use the Insert+Shift+s context menu again and arrow to Rename. HTH, Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 8:33 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, What I want to do is to take a worksheet copy all the data, including formulas, and paste it into a new worksheet. Iwant to take some spreadsheets I have recieved for doing certain statistical calculations. This way I can group the different sheets into workbooks so that I don't have so many single worksheets to open for tests and the like for my stats class. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 5:34 PM, Alan Robbins wrote: Greg, Could you be more specific as to what you want to do? I can help with either of the following: Do you want to select all data on a worksheet and paste into a new worksheet in the same book? Or, do you want to select an entire worksheet and move or copy to a new book? Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 3:59 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. -- Yesterday is forever gone, tomorrow may never come, today is the day of all days. 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/ 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/ 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/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
You misread the message from Annette. This is an Excel menu, not a JAWS menu. You do not use the Insert key. It is just Control + Shift + s. Thanks Annette, this is much easier. *Don Marang* Vinux Software Development Coordinator - vinuxproject.org http://www.vinuxproject.org/ There is just so much stuff in the world that, to me, is devoid of any real substance, value, and content that I just try to make sure that I am working on things that matter. -- Dean Kamen On 12/1/2011 8:49 AM, Icewolf wrote: Hello, For some reason insert plus shift plus s brings up the system menu in Excel 2010 using JAWS13. It will not bring up that menu you mentioned. I have noticed that a lot of Office commands don't work like they use to with JAWS13. Ihad to route jaws to pc, do a control end, find the name of the sheet, and do a right click on it to get the menu you described. Thats the way Don mentioned how to do it in his post. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 9:36 PM, Annette Carr wrote: To have a copy of the worksheet put in the same workbook or a different one: 1. Open the workbook where the original worksheet is. 2. If you are wanting to put the copy of the original worksheet into an existing workbook, open that file. If you are just making a copy of the sheet inside the file where it already exists, or if you want to put it in a new workbook, skip this step. 3. Use Insert+Shift+s to bring up a context menu. 4. Arrow down to copy/move worksheet and press Enter. 5. A dialog box comes up with 3 things that you need to deal with. 5.1 Where do you want the sheet to go? Same workbook, a new workbook or another existing workbook. This is a combo box. 5.2 Where do you want the sheet to be placed in the workbook, Before...? This a list box. 5.3. Are you moving the sheet, or making a copy. If making a copy be sure to put a check in the check box. If you are copying the sheet in the workbook where it already exists, the name of the new worksheet will have a 2 added to its name. If you want to rename this sheet, use the Insert+Shift+s context menu again and arrow to Rename. HTH, Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 8:33 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, What I want to do is to take a worksheet copy all the data, including formulas, and paste it into a new worksheet. Iwant to take some spreadsheets I have recieved for doing certain statistical calculations. This way I can group the different sheets into workbooks so that I don't have so many single worksheets to open for tests and the like for my stats class. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 5:34 PM, Alan Robbins wrote: Greg, Could you be more specific as to what you want to do? I can help with either of the following: Do you want to select all data on a worksheet and paste into a new worksheet in the same book? Or, do you want to select an entire worksheet and move or copy to a new book? Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 3:59 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. -- Yesterday is forever gone, tomorrow may never come, today is the day of all days. 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/ 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/ 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/
[JAWS-Users] Selecting an entire worksheet in Excel2010
Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. -- Yesterday is forever gone, tomorrow may never come, today is the day of all days. For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
Greg, Could you be more specific as to what you want to do? I can help with either of the following: Do you want to select all data on a worksheet and paste into a new worksheet in the same book? Or, do you want to select an entire worksheet and move or copy to a new book? Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 3:59 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. -- Yesterday is forever gone, tomorrow may never come, today is the day of all days. 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/
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
To select all cells in a worksheet, simply press Control + a. Then you can Press Control +c to copy and go to the next worksheet using Control + PageDown. Finally paste all of the cells with Control + v. It may be easier to move or copy the worksheet, rename the sheet, or other worksheet manipulation rather than cutting and pasting. The worksheet names are located at the bottom of the window. By default, they are simply named sheet 1, sheet 2, sheet 3, and so on. There probably is a better way to do this, but I turn on the JAWS Cursor with the NumPad minus (-). Then press PageDown to get to the bottom of the window. Find the sheet name that you want to manipulate by using the Control +Right Arrow keys several times. Now simulate a right mouse click with the NumPad star (*) keys. This will bring up a context menu of actions you can take on that sheet. *Don Marang* Vinux Software Development Coordinator - vinuxproject.org http://www.vinuxproject.org/ There is just so much stuff in the world that, to me, is devoid of any real substance, value, and content that I just try to make sure that I am working on things that matter. -- Dean Kamen On 11/30/2011 3:59 PM, Icewolf wrote: Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
Hello, What I want to do is to take a worksheet copy all the data, including formulas, and paste it into a new worksheet. Iwant to take some spreadsheets I have recieved for doing certain statistical calculations. This way I can group the different sheets into workbooks so that I don't have so many single worksheets to open for tests and the like for my stats class. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 5:34 PM, Alan Robbins wrote: Greg, Could you be more specific as to what you want to do? I can help with either of the following: Do you want to select all data on a worksheet and paste into a new worksheet in the same book? Or, do you want to select an entire worksheet and move or copy to a new book? Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 3:59 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. -- Yesterday is forever gone, tomorrow may never come, today is the day of all days. 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/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
To have a copy of the worksheet put in the same workbook or a different one: 1. Open the workbook where the original worksheet is. 2. If you are wanting to put the copy of the original worksheet into an existing workbook, open that file. If you are just making a copy of the sheet inside the file where it already exists, or if you want to put it in a new workbook, skip this step. 3. Use Insert+Shift+s to bring up a context menu. 4. Arrow down to copy/move worksheet and press Enter. 5. A dialog box comes up with 3 things that you need to deal with. 5.1 Where do you want the sheet to go? Same workbook, a new workbook or another existing workbook. This is a combo box. 5.2 Where do you want the sheet to be placed in the workbook, Before...? This a list box. 5.3. Are you moving the sheet, or making a copy. If making a copy be sure to put a check in the check box. If you are copying the sheet in the workbook where it already exists, the name of the new worksheet will have a 2 added to its name. If you want to rename this sheet, use the Insert+Shift+s context menu again and arrow to Rename. HTH, Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 8:33 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello, What I want to do is to take a worksheet copy all the data, including formulas, and paste it into a new worksheet. Iwant to take some spreadsheets I have recieved for doing certain statistical calculations. This way I can group the different sheets into workbooks so that I don't have so many single worksheets to open for tests and the like for my stats class. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 5:34 PM, Alan Robbins wrote: Greg, Could you be more specific as to what you want to do? I can help with either of the following: Do you want to select all data on a worksheet and paste into a new worksheet in the same book? Or, do you want to select an entire worksheet and move or copy to a new book? Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 3:59 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. -- Yesterday is forever gone, tomorrow may never come, today is the day of all days. 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/ 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/
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
Don, Try using Insert+Shift+s to do things to your worksheets. Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Don Marang Sent: Wednesday, November 30, 2011 5:36 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 To select all cells in a worksheet, simply press Control + a. Then you can Press Control +c to copy and go to the next worksheet using Control + PageDown. Finally paste all of the cells with Control + v. It may be easier to move or copy the worksheet, rename the sheet, or other worksheet manipulation rather than cutting and pasting. The worksheet names are located at the bottom of the window. By default, they are simply named sheet 1, sheet 2, sheet 3, and so on. There probably is a better way to do this, but I turn on the JAWS Cursor with the NumPad minus (-). Then press PageDown to get to the bottom of the window. Find the sheet name that you want to manipulate by using the Control +Right Arrow keys several times. Now simulate a right mouse click with the NumPad star (*) keys. This will bring up a context menu of actions you can take on that sheet. *Don Marang* Vinux Software Development Coordinator - vinuxproject.org http://www.vinuxproject.org/ There is just so much stuff in the world that, to me, is devoid of any real substance, value, and content that I just try to make sure that I am working on things that matter. -- Dean Kamen On 11/30/2011 3:59 PM, Icewolf wrote: Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. 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/
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
You can move or copy a worksheet to somewhere else in the work book or to a different workbook. Find the command under --are you ready?-- home lower ribbon format arrow down a bunch good luck! At 07:32 PM 11/30/2011, you wrote: Hello, What I want to do is to take a worksheet copy all the data, including formulas, and paste it into a new worksheet. Iwant to take some spreadsheets I have recieved for doing certain statistical calculations. This way I can group the different sheets into workbooks so that I don't have so many single worksheets to open for tests and the like for my stats class. Thanks, Greg W. Yesterday is forever gone, tomorrow may never come, today is the day of all days. On 11/30/2011 5:34 PM, Alan Robbins wrote: Greg, Could you be more specific as to what you want to do? I can help with either of the following: Do you want to select all data on a worksheet and paste into a new worksheet in the same book? Or, do you want to select an entire worksheet and move or copy to a new book? Al -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 3:59 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Selecting an entire worksheet in Excel2010 Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. -- Yesterday is forever gone, tomorrow may never come, today is the day of all days. 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/ 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/
Re: [JAWS-Users] Selecting an entire worksheet in Excel2010
Thanks Annette, I knew there was a shortcut, I just do not use it that much. I still use many workbooks created back in 1994 on a Mac. *Don Marang* Vinux Software Development Coordinator - vinuxproject.org http://www.vinuxproject.org/ There is just so much stuff in the world that, to me, is devoid of any real substance, value, and content that I just try to make sure that I am working on things that matter. -- Dean Kamen On 11/30/2011 9:39 PM, Annette Carr wrote: Don, Try using Insert+Shift+s to do things to your worksheets. Annette -Original Message- From: jaws-users-list-boun...@jaws-users.com [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Don Marang Sent: Wednesday, November 30, 2011 5:36 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Selecting an entire worksheet in Excel2010 To select all cells in a worksheet, simply press Control + a. Then you can Press Control +c to copy and go to the next worksheet using Control + PageDown. Finally paste all of the cells with Control + v. It may be easier to move or copy the worksheet, rename the sheet, or other worksheet manipulation rather than cutting and pasting. The worksheet names are located at the bottom of the window. By default, they are simply named sheet 1, sheet 2, sheet 3, and so on. There probably is a better way to do this, but I turn on the JAWS Cursor with the NumPad minus (-). Then press PageDown to get to the bottom of the window. Find the sheet name that you want to manipulate by using the Control +Right Arrow keys several times. Now simulate a right mouse click with the NumPad star (*) keys. This will bring up a context menu of actions you can take on that sheet. *Don Marang* Vinux Software Development Coordinator - vinuxproject.org http://www.vinuxproject.org/ There is just so much stuff in the world that, to me, is devoid of any real substance, value, and content that I just try to make sure that I am working on things that matter. -- Dean Kamen On 11/30/2011 3:59 PM, Icewolf wrote: Hello all, With JAWS13, how do I select an entire worksheet in Excel2010 to paste it into another sheet? Thanks, Greg W. 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/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
