Hided values appears when I'm copying/pasting it to other worksheet

A

Aivaras_Bakanas

So,

in one worksheet I have some data and there is some colums hided.
When I selecting all that data and pasting to other worksheet, al
these hided colums or rows values appears and I have to hide it again.

Is there possibility to copy/paste in such way, that these hided value
don't appear again?

Thanks in advance

Best Regards,
Aivara
 
D

Dave Peterson

Select the range to copy
edit|goto|special|visible cells only

Then copy|paste

(but this pastes formulas as values--is that a problem?)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying rows values on one sheet to part of a formula in a column 3
Copy only specific information from one colum to another worksheet 2
Copy and pasting values of filtered rows 1
How to summarize 3-4 worksheets worth of data into a summary scree 9
Row height changes when copying and pasting 2
Force values-only when pasting text to keep formatting 2
Copying rows values on one sheet to part of a formula in a column onanother sheet. 2
macros for copying external data to Excel 2

Top