Copy Values (XP)

[jrw5180]

Isn't there a way to copy a worksheet that has hidden rows/columns and paste it into a new sheet with those columns still hidden OR not even there?

[sdckapr]

Yes to both

To copy with the hidden rows, rt-click the worksheet tab
move or copy
check "create a copy"
<ok>

To copy a region and NOT copy the hidden items:
Select the range
Edit - goto - special
check "visible cells only"
<ok>
edit -copy
Go to the sheet to copy
edit -paste

Steve

[jrw5180]

Thanks Steve! That is perfect.