Removing A Formula In Excel

[andy-hughes]

I have data on an Excel spreadsheet that i want to place on another Excel spreadsheet, but it won;t let me copy and paste it.

I have tried pasting the data into a Word document, but again it won;t allow.

I suspect there may be a rogue formula lurking - how do i find and remove it please?

[ToraToraTora]

easier to save as another name then delete the bits you don't want in the new named doc.

[Old_Geezer]

Can you put it in notepad and then adjust it from there ?

Is any portion of the data directly movable ?

[archibaldy]

If you do want to check the original data, pressing CTRL + ` will show formulas.

[THECORBYLOON]

Do you get any error messages?

If you are trying to copy multiple cells, have you tried copying blocks at a time to narrow it down?

[andy-hughes]

Thanks all - I have figured it out. I just needed to move the right column border along to make all the data appear in the A column, then it transferred.

Thank you for all the advice, I may be back (!)