Apr 19, 2020 · Join Date 07-21-2013 Location washington dc MS-Off Ver 365 MSO Posts 473

May 17, 2017 · Anyways, is there anyway to drag a formula without changing the format of the cells? I have been using the CTRL+R (or D if its down) function which is useful, but changes the cell formats. I know that you can drag the formula from the bottom right of the cell, then click "fill without formatting" from the dropdown box. However, this is annoying.

Nov 29, 2015 · This is done in the conditional formatting for the cell (within the worksheet). In Excel 2003, it's Format->Conditional Formatting... ALT+O+D. In Excel 2007, it's in the Home section, so ALT+H+L+R) You can put this conditional formatting in for A2, then copy and paste the formatting onto the other cells you want it applied to.

Aug 11, 2012 · Re: Conditional Formatting without 'Fill' In the conditional formatting dialog box, make sure you have the Fill set to 'No Color'. It is a big button above the colors (at least on my Excel 2007).

Sep 2, 2014 · Then the Conditional formatting is =testing = "F0" Explanation: The code converts the target cell in column A from text formatted to Number formatted or back when the user double clicks on the cell. The conditional formatting turns the row blue if the cell in Column A …

Join Date 12-05-2011 Location Dubai, UAE MS-Off Ver 1997 - 2016 Posts 8,191

Nov 6, 2014 · I use the following fill formula but need it to do so now without formatting Thanks so much! 'Drags All formulas down as long as there is data Range("B2:B2").AutoFill Destination:=Range("B2:B" & Cells(Rows.Count, "G"

Aug 2, 2013 · When I do this manually, I enter the formula in the first cell, right-click on the bottom right corner of that cell, drag, then select "Fill without formatting", and this works perfectly. So I record this as a macro so I can genericize it: 1. Relative ranging:

Jun 20, 2017 · Join Date 07-15-2010 Location The Great City of Manchester, NW England ;-) MS-Off Ver MSO 2007,2010,365 Posts 48,204

Jun 20, 2006 · formatting" so I don't have to go through paste options each time? Same with using autofill - can I set the default to "fill without formatting"? Also, occasionally the paste options don't come up properly - after I paste something the paste options icon pops up but the arrow next to it isn't there and I can't click on it to access the paste ...