| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special "All" doesn't actually do "all".
I'm confused with Excel 2003 and Paste Special. If I copy cells from another
doc and I want to paste the cells AND the column widths into another Excel doc, I tried Paste Special All. That pastes only the contents. Not the Column Width. I have to Paste Special Column Widths, then paste the contents. Why is All not All? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special "All" doesn't actually do "all".
Can you try two step approach here?
1) Paste Special column width 2) then Paste Special ALL -kc *Click YES if this works. "GummybearsGummybearsLiveOnTheMoon" wrote: I'm confused with Excel 2003 and Paste Special. If I copy cells from another doc and I want to paste the cells AND the column widths into another Excel doc, I tried Paste Special All. That pastes only the contents. Not the Column Width. I have to Paste Special Column Widths, then paste the contents. Why is All not All? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special "All" doesn't actually do "all".
Column widths are included in "All" only if entire columns are selected.
Copying just cells requires the second step of pasting column widths. Gord Dibben MS Excel MVP On Wed, 16 Sep 2009 12:52:01 -0700, GummybearsGummybearsLiveOnTheMoon rosoft.com wrote: I'm confused with Excel 2003 and Paste Special. If I copy cells from another doc and I want to paste the cells AND the column widths into another Excel doc, I tried Paste Special All. That pastes only the contents. Not the Column Width. I have to Paste Special Column Widths, then paste the contents. Why is All not All? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Paste Special "All" doesn't actually do "all".
That is correct. I think the user is trying to copy some set of cells and not
the entire column. -kc "Gord Dibben" wrote: Column widths are included in "All" only if entire columns are selected. Copying just cells requires the second step of pasting column widths. Gord Dibben MS Excel MVP On Wed, 16 Sep 2009 12:52:01 -0700, GummybearsGummybearsLiveOnTheMoon rosoft.com wrote: I'm confused with Excel 2003 and Paste Special. If I copy cells from another doc and I want to paste the cells AND the column widths into another Excel doc, I tried Paste Special All. That pastes only the contents. Not the Column Width. I have to Paste Special Column Widths, then paste the contents. Why is All not All? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
