Thu 4 Jun 2009, 15:52Delegate Anne said...
Anne has attended:
Excel Intermediate course
Copy and pasting
How do you copy and paste rows from one workbook into another without copying and pasting hidden rows at the same time?
Mon 8 Jun 2009, 11:37Trainer Anthony said...
RE: Copy and pasting
Hi Anne, thanks for your query. Try selecting:
EDIT > GOTO > SPECIAL > VISIBLE CELLS ONLY > Then copy and paste as normal. Only the visible cells should be copied to the clipboard, thus ignoring the hiden rows.
Hope this helps,
Anthony
