Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |