Otherwise, it will paste the selected format wherever you click. Note: Once you are done copying the format, dont forget to click the Format Painter again to unlock the tool. Now you can click on all the target cells you wish to have the same formatting. Tips and Tricks Double-clicking on Format Painter locks the tool so you can easily copy the formatting to the cells that are not adjacent.įirst, you select the source cell, then double-click Format Painter. You can also hold Shift F10 instead of Alt E, which brings up the cells Context menu.Īlt E displays the regular system menu.) Macro Developing a special macro allows you to get a real single-key shortcut.Ĭheck out what an example of this macro looks like: Sub PasteSpecialFormats() If Application.CutCopyMode False Then Beep MsgBox No formatting in Clipboard Else Selection.PasteSpecial Paste:xlFormats End If End Sub After you develop the macro, you can assign a shortcut to it, which makes using the tool much easier. This action actually launches Paste Special and selects the option to paste the format only. Now, choose the target cells (the ones you want to reformat) and hit Alt E, S, T, then Enter. Shortcut Sequence Select the source cell (the one with the format you want to use) and hit Ctrl C (Cmd C on a Mac) to copy it to Clipboard. Instead, you need to apply a series of actions or a special macro. We have also included some useful tips and tricks on how to take full advantage of the tool.Įxcel Quick Links Excel Shortcut Sequence Macro Tips and Tricks Word Some Notes PowerPoint Step 1 Step 2 Step 3 Paint the Final Paragraph Format Excel doesnt feature a single keyboard shortcut to access the Format Painter tool. This article focuses on Format Painter shortcuts that can speed up your workflow.
0 kommentar(er)
