Tuesday, October 19, 2010

Excel - Copy and Paste Cells that Are Not Hidden Only

  1. Highlight everything you need to copy
  2. EDIT > GOTO > SPECIAL > VISIBLE CELLS ONLY > 
  3. Then copy and paste as normal. You should only copy the non-hidden cells.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...
Web Design & Marketing - Click and get an instant quote on your project