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

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO