moderated Re: Copying contents of a sheet

Matthew Bullis
 

Hello, the unique thing with Excel is that if you press control A for
select all, it will select only the current data range, stopping where
there are blank cells, regardless if there are more cells in the
worksheet. If you press control A a second time, the entire worksheet
will be selected. Then you can copy and paste into another worksheet.
In the Home ribbon under format cells, there are a bunch of options
for renaming and creating worksheets, and you'll want to rename that
second worksheet quickly, as well as make alterations to the copied
set of data. In that list of options is the copy worksheet option, but
the method I used above works as well.
Matthew

On 3/3/20, Jschliff@... <Jschliff@...> 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.



Joseph



From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Doering
Sent: Tuesday, March 3, 2020 12:53 PM
To: main@jfw.groups.io
Subject: Copying contents of a sheet



Hello:

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
Mobile:
445 S Curtis Rd West Allis, WI 53214
https://ibvi.org



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 main@jfw.groups.io to automatically receive all group messages.