Copying/Pasting Hidden Cells in Excel
Popomme
-
Patrice33740 Posted messages 8400 Registration date Status Member Last intervention -
Patrice33740 Posted messages 8400 Registration date Status Member Last intervention -
Hello,
I tried to find a solution, but I don't seem to have found one for my problem!
In fact, I would like to be able to keep the configuration of my hidden cells when I copy them to a new sheet. I can manage to copy my table while hiding the cells, but I can't keep them in my new table...
I hope I was clear and I thank you for any help you can provide!
I tried to find a solution, but I don't seem to have found one for my problem!
In fact, I would like to be able to keep the configuration of my hidden cells when I copy them to a new sheet. I can manage to copy my table while hiding the cells, but I can't keep them in my new table...
I hope I was clear and I thank you for any help you can provide!
1 answer
-
Hello,
In Excel, it's not possible to hide cells; you can only hide either rows, or columns, or both.
In order for Excel to copy hidden rows or columns, you need to copy the entire range that includes the hidden part.
For hidden rows (but not filtered): copy whole rows including at least one row above and one row below.
The same applies to columns.
And if both are hidden, you need to copy all cells from the sheet.
--
Best regards
Patrice
