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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Paste problem in Excel 2007 1
Copy & Paste 1
Moving a bunch of data 1
Excel2007: copying filtered table values, how can I copy ONLY thefiltered values 2
Macro to copy value in field and insert it into filter 2
Excel 2007 Paste Problem 2
Copy and paste the cell boarder only not the content 3
Copy & Paste Problem. 2

Back
Top