Close

Not a member yet? Register now and get started.

lock and key

Sign in to your account.

Account Login

Forgot your password?

SOLVED: VIDEO: How to Select Copy Paste Only The Visible Cells in Excel

If you want to select copy paste only the visible cells in Excel:

  1. In Excel 2007, 2010, 2013 or Excel 2016, select the cells you are interested in
  2. On the HOME tab, click SELECT GOTO
  3. Click GOTO SPECIAL
  4. Click VISIBLE CELLS ONLY
  5. Right click on the cells you selected in step 1 and click COPY
  6. Paste the cells wherever you want and you will see it took only the visible cells

Share This With Your Friends Now:
Facebooktwittergoogle_plusredditpinterestlinkedin

Leave a Reply