To copy only visible cells in Excel or Google Sheets, ... Phone Number, City, and Purchase Amount. In the dataset, rows 2 and 3 are grouped, and column D has been hidden.