| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto date change | Excel Discussion (Misc queries) | |||
| auto change line | Excel Discussion (Misc queries) | |||
| date auto change | Excel Discussion (Misc queries) | |||
| Auto fill color change | Excel Discussion (Misc queries) | |||
| Auto color change | Excel Discussion (Misc queries) | |||
Hybrid Mode
