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 View tab, select Visible cells only, Paste into the destination worksheet
- On the Home tab, clear the Hidden cells check box. Paste into the destination worksheet
- Copy the cells. Then in the destination worksheet, click Paste special > Paste only visible cells
- On the Home tab, click Find & Select > Go to special > Visible cells only. Paste into the destination worksheet
The correct answer is:
- On the Home tab, click Find & Select > Go to special > Visible cells only. Paste into the destination worksheet
🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers