Easy. After selecting your range:
1. Go to the 'Edit' menu
2. Select 'Go To...'
3. Ignore the first dialog that appears and click 'Special...'
4. Check 'Visible Cells Only' (right-hand side, 3rd option from bottom)
5. Click 'OK'
Then do your Paste/whatever other function you wish to apply only to the visible cells in the selected range.
Regards,
MB
Quote:
|
Originally Posted by Dave Peterson
I think you'll have to copy and paste in pieces--do each area of the visible
range separately.
Huber57 wrote:
I have hidden some rows in my workbook. I would like to paste some data
over these hidden cells and allow the data to skip them.
For example, if I have hidden Columns B and C and I paste 1, 2, 3, 4 (all
from different cells) into a row, 1 should appear in A1, 2 should appear in
D1, 3 should appear in E1, etc. Do you know how I can skip hidden rows when
I paste data?
I am using Excel 2003.
Sincerely,
huber 57
--
Dave Peterson
|