My problem is i have made a worksheet for work to enter data for testin
we perform, but on this worksheet i need to copy a graph from anothe
worksheet. Problem is the graph worksheet cell widths are vey smal
like 1.29 (38 cells) and height is 3.75 (93 cells), now if i copy the
onto the other worksheet it will resize the cells to that worksheet
and the graph will be huge like over 5 pages, and if i manually resiz
the cells back to 1.29 you will be able to see the graph but wont b
able to read the data, as the cell width is way to small. Is there
way to copy a selection from a worksheet to another worksheet withou
resizing the cells

--
top-da
-----------------------------------------------------------------------
top-dad's Profile: http://www.excelforum.com/member.php...fo&userid=3495
View this thread: http://www.excelforum.com/showthread.php?threadid=54689

top-dad wrote:
> My problem is i have made a worksheet for work to enter data for
> testing we perform, but on this worksheet i need to copy a graph from
> another worksheet. Problem is the graph worksheet cell widths are vey
> small like 1.29 (38 cells) and height is 3.75 (93 cells), now if i
> copy them onto the other worksheet it will resize the cells to that
> worksheet, and the graph will be huge like over 5 pages, and if i
> manually resize the cells back to 1.29 you will be able to see the
> graph but wont be able to read the data, as the cell width is way to
> small. Is there a way to copy a selection from a worksheet to another
> worksheet without resizing the cells.

Edit->Paste special... then Values or Formulas

Definetly does not work i have tried all the special paste commands, as
i said its 40 rows across and it keeps saying you need the same sized
square, and the worksheet im trying to paste onto has only 12 cells
across and if i resize it i wont be able to read the data at all.


--
top-dad
------------------------------------------------------------------------
top-dad's Profile: http://www.excelforum.com/member.php...o&userid=34957
View this thread: http://www.excelforum.com/showthread...hreadid=546893