9 replies
by geoffreyc
by jamiek
by jpeterson
by jamiek
by super cooler
by jamiek
by dfowler
Paste special is probably the best solution if the cells are random. If you want to copy entire rows, here's another variation:
1. Select the entire row (by clicking and dragging on the row numbers at the left)
2. Right click and choose COPY
3. Go to the new workbook or worksheet and position your insertion point at the row below where you want the new rows to be inserted
4. Right click and choose INSERT COPIED CELLS and it works much like Paste Special - pastes with all formatting intact
by jamiek
by jamiek
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending