moderated Re: Copying contents of a sheet

Jim Pursley

Didn't work for me, Mike, but JAWS key/shift/s brings up a handy little list of things you can do with spreadshheets (assume Excel though I did  not see the original question) including move/copy. I've found it faster and easier to do the cursor in A1/control A to highlight the whole sheet, control C to copy and on the new sheet in A1to press control v and I'm done. an

On 3/3/2020 6:59 PM, Ann Byrne wrote:
Another way to do it is to press alt+h, then o, then m to get into the move/copy sheet dialog.  Select  the sheet you want to copy before, then Tab once to 'copy' and check it.  At 12:12 PM 3/3/2020, you wrote:
Hi John,

Place your cursor on the first or beginning cell
Press shift + Ctrl then the end button.  This highlights all your cells from the first cell to the last cell.  All rows and columns in your range will be highlighted.
Then press ctrl + C to copy the cells
Move to your new sheet locate the cell where you would like to begin your paste
Once you have your cursor where you want to begin press Ctrl +V to paste

If you have special paste requirements use the application button instead of the Ctrl + V combo keystrokes.


From: <> On Behalf Of John Doering
Sent: Tuesday, March 3, 2020 12:53 PM
Subject: Copying contents of a sheet

I need to copy the contents of a sheet and paste the contents into another sheet in another workbook.  The trick is that I do not know which cells in the sheet contain data.
Any suggestions on how to find out what range of cells have data.  Then the best way to select that area to copy to the new sheet.
Any suggestions will be appreciated.

Thanks in advance,

John Doering
Pricing Analyst

Office: 4147783040 Extn:4063
445 S Curtis Rd West Allis, WI 53214


Industries for the Blind & Visually Impaired accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.

Join to automatically receive all group messages.