ExcelBanter - How Can I copy a sheet that has hidden rows without copying the h.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How Can I copy a sheet that has hidden rows without copying the h. (https://www.excelbanter.com/excel-worksheet-functions/9139-how-can-i-copy-sheet-has-hidden-rows-without-copying-h.html)

ibrahim

How Can I copy a sheet that has hidden rows without copying the h.

How Can I copy a sheet that has hidden rows without copying the hidden rows?
Thanks

Norman Jones

Hi Ibrahim,

Select the range to copy | F5 | Special | Select "Visible Cells" option.

Now copy.

---
Regards,
Norman

"ibrahim" wrote in message
...
How Can I copy a sheet that has hidden rows without copying the hidden
rows?
Thanks

All times are GMT +1. The time now is 11:29 PM.