Copy and past in office 2007

B

Bhaweshkr

When i use copy on filtered data and paste it to another sheet i am not able
to paste the axact data as the rows coming in between also comes together
 
D

Dave Peterson

Add an extra step.

After you've filtered the data, select the data
Hit F5 (or ctrl-g, same as Edit|Goto in xl2003 menus)
Click on Special
Then Visible cells only

Then do the copy|paste

Alt-; (alt-semicolon) is the shortcut key for selecting visible cells.
 
Top