I couldn't agree more!

Excel should allow the option to Paste Special without updating the
references and keeping the exact same formulas as the in the original
(without having to turn the original into absolute ones).

This is useful when replicating tables that use slightly different
information sources but in which the bulk of the references are the same as
in the original table.



"Dan Nichols" wrote:

Paste special is fine if you want to choose it every time you paste
something, this has been available since I started using office.

The new feature in word lets you choose the default action when you CTRL-V,
so you don't have to keep choosing paste special from the menu to simply
paste text (or values) without formatting.

The new options in word make pasting (paste-special) lots of times far
quicker and less labourious.

"JLatham" wrote:

Copy | Paste Special choose [Values] doesn't fulfill your need? Copies value
only, not formatting or formula.

"Dan Nichols" wrote:

At last MS have given the humble user the ability to set a default option on
the paste command in Word 2007, hurray.

You can set this in Word OptionsAdvancedCut, Copy and Paste section. No
more cross document formatting and styles to worry about.

So why can't we have the same feature in Excel?

The same section is Excel lacks the options available in Word.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc