Copying cells downward on sheet
 

Is there a way to copy rows and colums down and keep the row height and width
the same?

no, you can paste column widths but no row heights.
you can paste just about anything else but not row heights.

-----Original Message-----
Is there a way to copy rows and colums down and keep the
row height and width
the same?
.

If you want to retain the destination row / column size, select Paste
Special | Values from the Edit menu.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"danlinksman" wrote in message
...
Is there a way to copy rows and colums down and keep the row height and
width
the same?

To copy the row formats (height) with the data, you must select the *entire*
row(s) by clicking in the row number labels, *not* just the cells
themselves.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"danlinksman" wrote in message
...
Is there a way to copy rows and colums down and keep the row height and
width
the same?