Multi selection copy problem

[Farhad]

Hi,

when i multi select cells from one sheet and copy and paste in another sheet
it copies the cells that i doidn't select them too what is wrong with my
excel?

any help would be so appriciated

 

[Conan Kelly]

Farhad,

Are there hidden rows/columns in the selection you are copying? Is the data
filtered? XL hides rows when filtering.

XL will copy everything that is selected, including hidden rows/columns.

After you make your selection, do an [Alt] + [;] key combination so XL will
adjust the selection to visible cells only.

HTH,

Conan

 

[Farhad]

Thank you Conan for your reply but i checked no rows are hidden and also the
another thing that i found is when i sort the sheet all formulas chage to
their value that is really wierd and i am working with Excel about 10 years
and never seen these things before.
--
Farhad Hodjat

Farhad,

Are there hidden rows/columns in the selection you are copying? Is the data
filtered? XL hides rows when filtering.

XL will copy everything that is selected, including hidden rows/columns.

After you make your selection, do an [Alt] + [;] key combination so XL will
adjust the selection to visible cells only.

HTH,

Conan

Hi,

when i multi select cells from one sheet and copy and paste in another
sheet
it copies the cells that i doidn't select them too what is wrong with my
excel?

any help would be so appriciated