Excel copy and paste

[Anne Girling]

I have tried to copy a worksheet with several columns and
rows of data and paste to another worksheet but I lose the
formatting of the rows and columns and then have to
manually reformat (I've tried to use paste special but
this doesn't help)

Also with the same worksheet I filtered the data down to a
group of rows and would like to copy this to another
worksheet and hide the other data or delete it to send it
to someone else. Is this possible?

Many thanks
Anne

 

[Anon]

I have tried to copy a worksheet with several columns and
rows of data and paste to another worksheet but I lose the
formatting of the rows and columns and then have to
manually reformat (I've tried to use paste special but
this doesn't help)

Row height is a property of the row, not of individual cells within the row.
Hence, it will only be copied if you copy the whole row, not a particular
cell or range from within the row. Similarly for columns.

Also with the same worksheet I filtered the data down to a
group of rows and would like to copy this to another
worksheet and hide the other data or delete it to send it
to someone else. Is this possible?

When you have filtered your data, select the rows you want to copy. At the
moment, this has actually selected all the rows, not just the visible ones.
So, you now need to use
Edit > Go To > Special > Visible Cells Only > OK
Now only the visible cells in your selection are selected, so you can copy
and paste as normal.

 

[Don Guillett]

pastespecial formats

On the second, a good way to learn is to record a macro of what you are
doing and then modify.

 

[Squeezo]

I have tried to copy a worksheet with several columns and
rows of data and paste to another worksheet but I lose the
formatting of the rows and columns and then have to
manually reformat (I've tried to use paste special but
this doesn't help)

Anne,

If you right click the tab for the worksheet that you wish to copy (at
the bottom of the spread sheet), it will give you a list of options
that may prove useful. Click on the one that says move/copy. It will
then ask you where you want to move the sheet to. There is also a
little tick box that lets you select 'make a copy'. Click this then
choose where abouts you wish the new copy to go. This will provide you
with a replica of the original sheet which you can play about with.

Alternative:
If you want to just paste 'values' and the 'cell format', then like
you have done before, highlight the area...click copy...then paste the
area where it is you want it. The detail within the cells may be wrong
but you will have the exact format. Press the 'delete' key to clear
the contents of the cells (the formula or whatever). It will leave you
with the format though. Then copy the original area again and paste
special the values or the formula or whatever over the formatted
cells.
I hope I understood the first part of your question correctly,
otherwise ignore all of what I have said and block me from your email
accounts.

Cheers
D

 

[Gail]

But you can not copy the sheet this way and paste within another sheet