I only discovered recently that copying and pasting rows from a filtered list resulted in only the filtered rows being pasted. Having used Excel for many years I had become familiar with the 'copy visible cells only' option in 'Go to Special' and was still using it. Anyone tell me at whet version this behaviour changed?