 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Copy Cells Found
I have Office XP. In one excel file I went to find to find a certain entry and found about 301 cells. How can I copy all these cells and paste in a new file? Sol Well it depends on if you need the whole row that coincides with those cells. The easiest way I found was to filter for the data then highlight the rows by clicking on the row number hold down the shift key and click on the bottom row, then ctrl C go to new sheet/file and ctrl V > I have Office XP. In one excel file I went to find to find a certain entry > and found about 301 cells. How can I copy all these cells and paste in a new > file? > Sol Thank You for your help.The problem is that each row has the beginning are all the same but they all end different. Sol > Well it depends on if you need the whole row that coincides with those cells. > The easiest way I found was to filter for the data then highlight the rows by [quoted text clipped - 5 lines] > > file? > > Sol |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.