Pasting over hidden columns

G

Guest

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
 
D

Dave Peterson

I think you'll have to copy and paste in pieces--do each area of the visible
range separately.
 
P

Peo Sjoblom

Have you really tried this, it certainly does not work for me? Hide columns
B and D, put 1 in H1, 2 in I1 and 3 in J1, copy H1:J1, now select columns
A:E, go to special and select visible cells only, paste the values, what do
you get?
 

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

Copy/Paste with Hidden Rows/Columns Excel 2007 3
Avoid pasting over hidden rows 1
Copy and Paste with hidden columns remaining hidden 2
drag data vertically over hidden cells.. ignore hidden cells 1
Possible Autofilter Bug (2003 and 2007) 5
pasting data on hidden cells 2
How do I keep colums hidden when pasting 1
Expand and Shrink Rows and columns to hide information. 1

Top