Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Go to Special Visible cells only
Columns A, J, K and L are visible.
Columns B to I are hidden. When I select a few rows using the shift key, click "visible cells only," click copy icon and paste icon, I only got column A pasted. I am surprised not to see J, K and L because to me they are visible as well. What have I missed? Appreciate explanation. Epinn |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Go to Special Visible cells only
As soon as I posted, I found my answer.
The copied data are copied into **consecutive** rows or columns. I had to unhide the paste area to see all of the copied cells. These two posts should help me remember in the future. Thanks for your attention. Were you going to give me the same answer? ;) Epinn "Epinn" wrote in message ... Columns A, J, K and L are visible. Columns B to I are hidden. When I select a few rows using the shift key, click "visible cells only," click copy icon and paste icon, I only got column A pasted. I am surprised not to see J, K and L because to me they are visible as well. What have I missed? Appreciate explanation. Epinn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying Formulas to Visible Cells Only | Excel Discussion (Misc queries) | |||
Paste Data into Contiguous (Visible) Cells | New Users to Excel | |||
apply arithmetic functions on special multiple cells | Excel Worksheet Functions | |||
Paste into visible cells | Excel Discussion (Misc queries) | |||
AutoFill Visible Cells with Months | New Users to Excel |