The Foreign Office stressed the paper, which resulted from a "brainstorm" on the visit, did not reflect its views.
The junior civil servant responsible had been put on other duties, it said.
Details of the document emerged after it was obtained by the Sunday Telegraph.
'Song with Queen'
The UK's ambassador to the Vatican, Francis Campbell, has met senior officials of the Holy See to express regret on behalf of the government.
Foreign Secretary David Miliband is said to have been "appalled" by its contents.
 | ANALYSIS  Robert Pigott, BBC religious affairs correspondent It's clear that what the Foreign Office has called "this foolish document" did not reflect government policy. Its tone is clearly frivolous, and it came from junior officials. But it has, nevertheless, the potential to cause considerable damage. Whether fairly or not, it will leave some Catholics with the impression of a culture within official circles in which their Church's teaching is not taken seriously. Some will suspect prejudice against faith groups. Perhaps most damaging of all, it could leave an impression that the Pope might be regarded as a figure of fun less than five months before his visit to Britain. Apart from the pressure on the papal visit from public feeling about sex abuse, and the threat of demonstrations against the Pope, the government needs the Vatican's help in a global diplomatic effort to curb climate change and fight poverty. How serious and far-reaching the effect of the document is depends partly on how the Church itself responds. |
It suggested Benedict XVI could show his hard line on the sensitive issue of child abuse allegations against Roman Catholic priests by "sacking dodgy bishops" and launching a helpline for abused children.
It went on to propose the Pope could apologise for the Spanish Armada or sing a song with the Queen for charity.
It listed "positive" public figures who could be made part of the Pope's visit, including former Prime Minister Tony Blair and 2009 Britain's Got Talent runner-up Susan Boyle, and those considered "negative", such as Manchester United striker Wayne Rooney and prominent atheist Richard Dawkins.
The civil servant responsible said in a cover note: "Please protect; these should not be shared externally. The 'ideal visit' paper in particular was the product of a brainstorm which took into account even the most far-fetched of ideas."
An investigation was launched after some recipients of the memo, said to have been circulated to a restricted list, objected to its tone.
A Foreign Office spokesman said the department was "deeply sorry" for any offence the document had caused.
"This is clearly a foolish document that does not in any way reflect UK government or Foreign Office policy or views. Many of the ideas in the document are clearly ill-judged, naive and disrespectful," he said.
"The text was not cleared or shown to ministers or senior officials before circulation. As soon as senior officials became aware of the document, it was withdrawn from circulation.
"The individual responsible has been transferred to other duties. He has been told orally and in writing that this was a serious error of judgement and has accepted this view."
'Blue-skies thinking'
The Foreign Office said the memo had resulted from discussions by a group of three or four junior staff in a team working on early planning for the papal visit.
A source told the BBC News website the individual who has since been moved to other duties had called the group together for "some blue-skies creative thinking about how to make the visit a success", but their discussions had become "a joke that has gone too far".
Earlier this year the Pope announced 2010 would see the first papal visit to the UK since John Paul II's visit in 1982.
Pope Benedict XVI's visit will take place from 16 to 19 September, during which time he is expected to visit Birmingham, as part of the planned beatification of Cardinal John Newman, and Scotland.
The visit will come in the autumn of what is proving to be a difficult year for the Pope with a wave of allegations that Church authorities in Europe and North and South America failed to deal properly with priests accused of paedophilia.
The Pope himself has been accused of being part of a culture of secrecy and of not taking strong enough steps against paedophiles when he had that responsibility as a cardinal in Rome.
However, his supporters say he has been the most pro-active pope yet in confronting abuse.
