1. Select the cells you want to copy.
2. Now go to the Ribbon. Go to the HOME tab, then EDITING group and click FIND & SELECT.
3. Click GO TO, then click Special...
4. Select Visible Cells Only", then click OK
5. On the Home tab, in the Clipboard group, click Copy
Keyboard shortcut You can also press CTRL+C.
6. Select the upper-left cell of the paste area.
Tip To move or copy a
selection to a different worksheet or workbook, click another worksheet
tab or switch to another workbook, and then select the upper-left cell
of the paste area.
7. On the Home tab, in the Clipboard group, click Paste
Keyboard shortcut You can also press CTRL+V.
*Applies to Excel 2007, Excel 2010 and Excel 2013
No comments:
Post a Comment