Re: How to set up a "ticked" rows

Tech-Archive recommends: Speed Up your PC by fixing your registry

See inline text correction below....

>I am an Excel newbie and want to select say 100 rows at various positions >down a 5000 row table then copy these to a new ***. Rather than copy >and paste each one I would like to set up a "tick" cell column in each >row so that somehow I can then automatically select all the ticked rows >then do a copy and paste.

As long as you are going to have to "tick" each row anyway, why don't you simply select the cells directly by pressing the Control Key while clicking

..... simply selects the ROWS directly....

Rick


each row header number (you can also Control-Click-Drag at any time to select multiple contiguous rows at any point) and then, once you have selected all of the rows, simply Edit/Copy (or press Ctrl+C), switch to the new *** and Edit/Paste (or press Ctrl+V) to complete the copy operation?

Rick

.

Quantcast