Copy Cells Found

  • Thread starter Thread starter S1L1Y1
  • Start date Start date
S

S1L1Y1

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
 
Thank You for your help.The problem is that each row has the beginning are
all the same but they all end different.
Sol
 

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

Unlink cells- how? 0
Add Same Text to All Cells in Column 2
Double Entries in Excel 3
Add Same in each cell in column 1
use VLookup to copy more than 1 cell 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
pasting content copied from nonadajacent cells 1

Back
Top