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 |
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 |
All times are GMT +1. The time now is 12:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com