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 |
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 |
All times are GMT +1. The time now is 04:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com