ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   copy and paste not functioning, think clipboard problem (https://www.excelbanter.com/excel-worksheet-functions/195657-copy-paste-not-functioning-think-clipboard-problem.html)

Jane, UK

copy and paste not functioning, think clipboard problem
 
I seem to be unable to copy and paste formulae - have always tended to use
control C and enter method of copying and pasting
Even when copying from a single cell to say remainder of column, get error
message, "Data on clipboard is note the same size and shape as selected area.
Do you want to paste the data anyway" - I click OK but all that does is to
change the formula in the source cell to a hard number value and none of the
rest of the pasting happens.

Susan

copy and paste not functioning, think clipboard problem
 
are you trying to handle merged cells? if so, that may be your
problem.
:)
susan


On Jul 21, 6:22*am, Jane, UK <Jane,
wrote:
I seem to be unable to copy and paste formulae - have always tended to use
control C and enter method of copying and pasting
Even when copying from a single cell to say remainder of column, get error
message, "Data on clipboard is note the same size and shape as selected area.
Do you want to paste the data anyway" - I click OK but all that does is to
change the formula in the source cell to a hard number value and none of the
rest of the pasting happens.




All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com