auto change
 

I am copying data from 1 worksheet to a 2nd worksheet. What I want the second
worksheet to do is change the column width and row height automatically. Can
some help me.
Thank you

auto change
 

There is a trick, but it is not automatic. After you Copy and Paste the
data. go to Paste Special on the Edit Menu. Select Format. this will copy
the format from the 1st worksheet to the 2nd worksheet.

"sharon" wrote:

I am copying data from 1 worksheet to a 2nd worksheet. What I want the second
worksheet to do is change the column width and row height automatically. Can
some help me.
Thank you

auto change
 

Joel I tried this but it didnt work. Any ideas why?

"Joel" wrote:

There is a trick, but it is not automatic. After you Copy and Paste the
data. go to Paste Special on the Edit Menu. Select Format. this will copy
the format from the 1st worksheet to the 2nd worksheet.

"sharon" wrote:

I am copying data from 1 worksheet to a 2nd worksheet. What I want the second
worksheet to do is change the column width and row height automatically. Can
some help me.
Thank you

auto change
 

Sharon

Copy your data and Paste then before hitting ENTER, Paste Specialcheck "Columns
Widths" but unless you select entire rows the row heights cannot be copied.


Gord Dibben MS Excel MVP

On Sun, 25 Feb 2007 19:50:05 -0800, sharon
wrote:

Joel I tried this but it didnt work. Any ideas why?

"Joel" wrote:

There is a trick, but it is not automatic. After you Copy and Paste the
data. go to Paste Special on the Edit Menu. Select Format. this will copy
the format from the 1st worksheet to the 2nd worksheet.

"sharon" wrote:

I am copying data from 1 worksheet to a 2nd worksheet. What I want the second
worksheet to do is change the column width and row height automatically. Can
some help me.
Thank you

auto change
 

when youdo the paste (not paste special) a square box will be display.
selectt on the Square box "keep source column width"

"sharon" wrote:

Joel I tried this but it didnt work. Any ideas why?

"Joel" wrote:

There is a trick, but it is not automatic. After you Copy and Paste the
data. go to Paste Special on the Edit Menu. Select Format. this will copy
the format from the 1st worksheet to the 2nd worksheet.

"sharon" wrote:

I am copying data from 1 worksheet to a 2nd worksheet. What I want the second
worksheet to do is change the column width and row height automatically. Can
some help me.
Thank you