You want to copy only the cells that are displayed here-not the hidden cells-into another worksheet. After selecting the cells in the worksheet, how do you accomplish this? On the Home tab, clear the Hidden cells check box. Paste into the destination worksheet. On the View tab, select Visible cells only. Paste into the destination worksheet. On the Home tab, click Find \& Select > Go To Special > Visible cells only. Paste into the destination worksheet. Copv the cells. Then, in the destination worksheet, click Paste Special > Paste Only Visible Cells