Right-click on the fill handle and drag.

Release button and select "fill without formatting"


Gord Dibben MS Excel MVP

On Fri, 26 Mar 2010 07:10:01 -0700, Dave Stewart
wrote:

Often I use borders and cell formatting to highlight columns or rows of my
document.

When I use the fill handle to propagate values, it always overwrites border
and cell formatting, thus wiping out my careful delineation of spreadsheet
areas.

It would be really useful if you could lock cells then simply drag to change
values, not formatting 9including conditional formatting).

Thanks.

----------------
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