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: [email protected] [mailto:[email protected]] On Behalf Of Icewolf Sent: Wednesday, November 30, 2011 8:33 PM To: [email protected] 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: [email protected] > [mailto:[email protected]] On Behalf Of Icewolf > Sent: Wednesday, November 30, 2011 3:59 PM > To: [email protected] > 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/
