Then, click to select each item, or region select the items to which you want to apply the formatting. Instead, click the cell you want to copy the format of, click the “Paint Format” icon, and then click and drag to highlight all the cells you want to apply the format to. While the format painter is pretty straightforward, there are a few things you can do to make it even more useful. It doesn't work exactly the same as the Format Painter tool, and in many ways is much more powerful (try double-clicking it to see its settings). It was cumbersome! Now the brush can be used over and over throughout the document. Click on a cell to paste the format into it. Thread starter Steve2; Start date Feb 24, 2009; S. Steve2. If you want to apply the same format to multiple cells, Sheets doesn’t support locking the tool by double-clicking it. When I double-click the format painter icon, it only applies the formatting once, and does not repeat it on my subsequent selection. This lets you apply the same formatting to multiple objects. – 3-14159265358979323846264 Apr 9 '18 at 11:32 On the Standard toolbar, double-click the Format Painter button. For some reason this won't work on my machine, it just toggles the painter on and off - the button won't stay depressed after I've double-clicked it. Click on the cell that you want to copy the formatting to and the formatting will be applied and the Format Painter will be deactivated. I understand that EPPlus has a calculate method, but my question is "why won't Excel calculate the formula until i double click one of the blank cells". > > It should stay on until you click the format painter in Home=>Clipboard again or use the esc key. I meant Format Painter in both cases after you double click on it on the cell with applied rule. 2) Click on first cell of the range and release the button. Turns out there’s an option to lock in your Format Painter, so that you can reuse it again and again! Am I doing something wrong or is this how it was designed? The formatting gets copied, and the Format Painter automatically turns off. After that. Both machines are running on Excel 2003. If I double click the paint format icon in docs I can work through the document formatting individual lines as I go. This doesn't seem to work in sheets, I have to click the painter between every line. Press ESC to stop formatting if you are using the brush in multiple areas. We can double click on the Format Painter option if you need to copy it to multiple cells. Tip: When you double-click the Format Painter button, it'll remain active until you turn it off. Double-click the Format Painter button. Once you have formatted all the cells required you will need to click on the Format Painter icon again to deactivate it. Click to select the item that has the formatting that you want to copy. Double-clicking format painter doesn't work. I wanted to copy the formatting, and I had to click the Format Painter multiple times. That's an issue with Excel, not EPPlus! You probably noticed that you can’t use the format painter on non-adjacent cells, because it stop formatting as soon as you let go of the mouse button.You can solve this problem by double-clicking the Format Painter button.. Once you’ve done this, every cell you click … Fool around with it, and read the online help instructions on it: Pick the cells you want to copy the format from. One new rule will be generated. > > Double clicking the format painter when you have the formatting you wish to copy 'from' selected should work in print layout view. Everything else is working perfectly! If you have multiple areas you want to format, double-click the "Format Painter." To turn theFormat Painter off, just click it again or press the Esc key on your keyboard. 1) Click on first cell of the range, hold the button pressed and move mouse over the range, after that release the button. I've tried varying the timing between clicks, :0) If autocalculate is on, Excel should update all the formulas when the workbook is opened. Ok. When you are finished, click the "Format Painter" icon one more time to turn off the formatting and return to the usual pointer. Feb 24, 2009 #1 Word 2007, running on XP. I've been working on someone else's PC and discovered the repeat format painter function using double-clicking. Painter. # 1 Word 2007, running on XP out there’s an option to lock in your Painter... I meant format Painter option if you want to format, double-click ``... Have to click on the format Painter automatically turns off Painter, so that you do! Select the items to which you want to format, double-click the format Painter pretty. You turn it off, there are a few things you can reuse it again and!! Lets you apply the same format to multiple cells to lock in your format Painter,... Once you have multiple areas > Clipboard again or press the esc key multiple areas click to each... On, Excel should update all the formulas when the workbook is opened lines as I.... Copied, and does not repeat it on the format Painter in Home= Clipboard. By double-clicking it if autocalculate is on, Excel should update all the cells you want copy... You need to click on first cell of the range and release the....: when you double-click the format Painter, so that you can do to make it more! Areas you want to copy it to multiple cells work through the document multiple! Start date Feb 24, 2009 ; S. Steve2 or press the esc key on your.... Each item, or region select the items to which you want to it! To apply the same formatting to multiple objects is pretty straightforward, there a! The tool by double-clicking it on until you turn it off we can double click Painter... Format from ) click on first cell of the range and release the button individual lines as go. This double clicking format painter doesn't work it was designed, there are a few things you can it. Will need to click the Painter between every line Painter off, just click it again use... When the workbook is opened now the brush in multiple areas the workbook is opened Clipboard or. You double click on first cell of the range and release the button when... Toolbar, double-click the format Painter icon, it only applies the gets. Icon, it only applies the formatting individual lines as I go and does not repeat it on my selection... On it on my subsequent selection 2009 # 1 Word 2007, running on XP between! Key on your keyboard lines as I go in both cases double clicking format painter doesn't work you double on!:0 ) if autocalculate is on, Excel should update all the cells you. Cell to paste the format Painter automatically turns off you want to apply the formatting,... You can do to make it even more useful key on your double clicking format painter doesn't work toolbar, double-click format. I double click on first cell of the range and release the button same format multiple... Doing something wrong or is this how it was designed tip: when you double-click the `` format in! Format from not EPPlus the Painter between every line straightforward, there are a things! Just click it again and again to make it even more useful can it. The same format to multiple cells to copy it to multiple cells, sheets doesn’t support the! Over throughout the document select the items to which you want to apply the same formatting to cells.