Product Suggestion: lock border and cell formatting only

[Dave Stewart]

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/com...c-55a27bd58348&dg=microsoft.public.excel.misc

 

[Gord Dibben]

Right-click on the fill handle and drag.

Release button and select "fill without formatting"


Gord Dibben MS Excel MVP

 

[pierson.craig]

This is very good product suggestion as it frustrates me too.

BTW Gord - Your response works fine for one single user, but if for examplea scheduling file was on a server, and many people throughout the company make changes to it.... see what I'm getting at? Even if they all knew how to do "fill without formatting", there always those lazy ones....

So yes there should be a way to force users to copy and paste values only.