copying area with different rows width
Posted by Eli Weiss on March 13, 2001 3:17 AM
Hi there,
How can I copy formatted area with different rows width
to another part in the same worksheet?
Thanks in advance
Eli
Posted by Mark W. on March 13, 2001 6:21 AM
Eli, suppose that cells A1:D4 contains...
1,2,,
1,2,3,
1,2,3,4
1,,,
...and you want to copy these values to A7:D10
which already contains...
,,"x","x"
,,,"x"
,,,
,"x","x","x"
First, select cells A1:D4 and perform a Copy.
Next, select cell A7 and do a perform a Paste
Special...Values, Skip blanks. When you're
done A7:D10 contains...
1,2,"x","x"
1,2,3,"x"
1,2,3,4
1,"x","x","x"
Posted by Eli Weiss on March 13, 2001 6:34 AM
Mark, thank you for your answer but sorry
my problem was to copy rows width !!!
supose that I formatted my first row to be 20 pix
wide and the second row 25, third 30 and so on
Now I want to copy the rows width from row 1 to 5 to lets say rows 16 to 20 how can I do it?
Thanks again
Eli
4
Posted by Mark W. on March 13, 2001 6:49 AM
Rows don't have width...they have height. Use
Copy/Paste Special...Formats.
Posted by Eli Weiss on March 13, 2001 7:15 AM
You are right of course
I tried what you suggested
but it dose not work
The height was still default
I would appreciate if you can be more specific
about the commands
Thanks
Eli
Posted by Mark W. on March 13, 2001 7:33 AM
Eli, since row height is a row attribute you must
select entire rows -- not cells -- before you Copy.
Posted by Eli Weiss on March 13, 2001 7:33 AM
OK
It is all right
I had to mark the whole row
Eli
