Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi selection copy problem
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi selection copy problem
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 "Conan Kelly" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple selection copy & paste across multi-worksheets | Excel Discussion (Misc queries) | |||
Multi Selection List/Combi Box | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Preventing Multi Cell Selection | Excel Discussion (Misc queries) | |||
Multi-selection problem in Excel XP and 2003 | Excel Discussion (Misc queries) |