Copying different sized cell width & height onto another worksheet

T

top-dad

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
 
P

Paul Lautman

top-dad said:
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
 
T

top-dad

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top