LinkedIn Microsoft Excel Certification

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?

October 30, 2022 Editorial Staff

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