Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copying cells downward on sheet
Is there a way to copy rows and colums down and keep the row height and width
the same? |
#2
|
|||
|
|||
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? . |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Automatic copying of data cells | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel |