Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Product Suggestion: lock border and cell formatting only
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Product Suggestion: lock border and cell formatting only
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect (Lock) Cell Formatting ONLY | Excel Discussion (Misc queries) | |||
border on last cell of page effects border on beginning cell of ne | Excel Discussion (Misc queries) | |||
Border Formatting Disappearing when data entered into cell | Excel Discussion (Misc queries) | |||
Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
lose formatting (border) in excel cell after pasting from word | Excel Discussion (Misc queries) |