Copy and past in office 2007

  • Thread starter Thread starter Bhaweshkr
  • Start date Start date
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
 
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.
 
Back
Top