View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 419
Default Multi selection copy problem

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" wrote in message
...
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
--
Farhad Hodjat