<!DOCTYPE html>
<html lang="en-US">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Copying Attributes With the Clone Formatting Tool</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="fuzzysort.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="en-US/langnames.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="en-US/bookmarks.js" defer></script><script type="text/javascript" src="en-US/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body itemscope="true" itemtype="http://schema.org/TechArticle">
<div class="header-extrawurst">
<header><div class="logo-container"><a class="logo" href="en-US/text/shared/05/new_help.html"><div class="symbol"></div>
<p>LibreOffice 6.4 Help</p></a></div></header><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" onclick="setupModules('', 'en-US');">Module</button><nav id="modules-nav"></nav>
</div>
</div>
<aside class="rightside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1">Contents</label><div id="Contents" class="contents-treeview"></div></aside><aside class="leftside"><div id="Index">
<div class="index-label">Index 🔎︎ </div>
<div id="Bookmarks">
<input id="search-bar" type="text" class="search" placeholder="Search in all modules"><nav class="index"></nav>
</div>
</div></aside><div id="DisplayArea" itemprop="articleBody">
<a name="paintbrush"></a>
<a name="bm_id380260"></a><meta itemprop="keywords" content="Format Paintbrush">
<meta itemprop="keywords" content="clone formatting">
<meta itemprop="keywords" content="formatting,copying">
<meta itemprop="keywords" content="copying,formatting">
<meta itemprop="keywords" content="Paintbrush">
<h1 itemprop="articleSection" id="par_idN1053A">
<a name="formatpaintbrush"></a>Copying Formatting With the Clone Formatting Tool
</h1>
<p id="par_idN10655" class="paragraph">You can use the Clone Formatting tool to copy formatting from a text selection or from an object and apply the formatting to another text selection or object.</p>
<div class="note">
<div class="noteicon"><img src="media/icon-themes/res/helpimg/note.svg" alt="Note Icon
" title="Note Icon
" style="width:40px;height:40px;"></div>
<div class="notetext"><p>In Calc, the Clone Formatting tool only applies to cell formatting.</p></div>
</div>
<br>
<ol>
<li>
<p id="par_idN106DD" class="paragraph">Select the text or object whose formatting you want to copy.</p>
</li>
</ol>
<ol start="2">
<li>
<p id="par_idN10667" class="paragraph">On the <span class="emph">Standard Bar</span>, click the <span class="emph">Clone Formatting</span> icon.</p>
<p id="par_idN10660" class="paragraph">The cursor changes to a paint bucket.</p>
<div class="tip">
<div class="noteicon"><img src="media/icon-themes/res/helpimg/tip.svg" alt="Tip Icon
" title="Tip Icon
" style="width:40px;height:40px;"></div>
<div class="notetext"><p>If you want to apply the formatting to more than one selection, double-click the <span class="emph">Clone Formatting</span> icon
<img src="media/icon-themes/cmd/sc_formatpaintbrush.svg" class="iconimage" alt="Icon" title="Icon" style="width:16px;height:16px">. After you apply all the formatting, click the icon again.</p></div>
</div>
<br>
</li>
<li>
<p id="par_idN1066E" class="paragraph">Select or click the text or object that you want to apply the formatting to.</p>
</li>
</ol>
<div class="tip">
<div class="noteicon"><img src="media/icon-themes/res/helpimg/tip.svg" alt="Tip Icon
" title="Tip Icon
" style="width:40px;height:40px;"></div>
<div class="notetext"><p>By default only the character formatting is copied ; to include paragraph formatting, hold down <span id="swlnsysidm36" class="switchinline"><span hidden="true" id="MACidm37" class="MAC">Command</span><span hidden="true" id="defaultidm38">Ctrl</span></span> when you click. To copy only the paragraph formatting, hold down <span id="swlnsysidm39" class="switchinline"><span hidden="true" id="MACidm40" class="MAC">Command
</span><span hidden="true" id="defaultidm41">Ctrl</span></span>+Shift when you click.</p></div>
</div>
<br>
<p id="par_idN10672" class="paragraph">The <span class="emph">paragraph</span> formats are the formats applied to the whole paragraph. The <span class="emph">character</span> formats are those applied to a portion of the paragraph. For example, if you apply the bold format to a whole paragraph the bold format is a <span class="emph">paragraph</span> format. Then if you unbold a portion of this paragraph, the bold format is still a <span class="emph">paragraph</span> format but the portion you unbold has a "not bold" <span class="emph">character</span> format.</p>
<p id="par_idN10671" class="paragraph">The following table describes the formatting attributes that the <span class="emph">Clone Formatting</span> tool can copy:</p>
<table border="1" class="" cellpadding="0" cellspacing="0">
<tr>
<td rowspan="" colspan="" class="tableheadcell">
<p id="par_idN10691" class="tableheadintable">Type of Selection</p>
</td>
<td rowspan="" colspan="" class="tableheadcell">
<p id="par_idN10697" class="tableheadintable">Comment</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_idN1069E" class="tablecontentintable">Nothing selected, but cursor is inside a text passage</p>
</td>
<td rowspan="" colspan="">
<p id="par_idN106A4" class="tablecontentintable">Copies the formatting of the current paragraph and the character formatting of the next character in the text flow direction.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_idN106AB" class="tablecontentintable">Text is selected</p>
</td>
<td rowspan="" colspan="">
<p id="par_idN106B1" class="tablecontentintable">Copies the formatting of the last selected character and of the paragraph that contains the character.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_idN106B8" class="tablecontentintable">Frame is selected</p>
</td>
<td rowspan="" colspan="">
<p id="par_idN106BE" class="tablecontentintable">Copies the frame attributes that are defined in <span class="menuitem">Format - Frame and Object - Properties</span> dialog. The contents, size, position, linking, hyperlinks, and macros in the frame are not copied.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_idN106C5" class="tablecontentintable">Object is selected</p>
</td>
<td rowspan="" colspan="">
<p id="par_idN106CB" class="tablecontentintable">Copies the object formatting that is defined in the <span class="menuitem">Format - Graphics</span> or <span class="menuitem">Format - Drawing Object</span> dialogs. The contents, size, position, hyperlinks, and macros in the object are not copied.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_idN106D2" class="tablecontentintable">Form control is selected</p>
</td>
<td rowspan="" colspan="">
<p id="par_idN106D8" class="tablecontentintable">Not supported</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_idN106DF" class="tablecontentintable">Drawing object is selected</p>
</td>
<td rowspan="" colspan="">
<p id="par_idN106E5" class="tablecontentintable">Copies all formatting attributes. In Impress and Draw, the text contents of the object is also copied.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_idN106EC" class="tablecontentintable">Text within Calc cells is selected</p>
</td>
<td rowspan="" colspan="">
<p id="par_idN106F2" class="tablecontentintable">Not supported</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_idN106F9" class="tablecontentintable">Writer table or cells are selected</p>
</td>
<td rowspan="" colspan="">
<p id="par_idN106FF" class="tablecontentintable">Copies the formatting that is specified in Table, Text Flow, Borders, and Background tab pages in the <span class="menuitem">Format - Table</span> dialog. The paragraph and character formatting are also copied.</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="">
<p id="par_idN10706" class="tablecontentintable">Calc table or cells are selected</p>
</td>
<td rowspan="" colspan="">
<p id="par_idN1070C" class="tablecontentintable">Copies the formatting that is specified in the <span class="menuitem">Format - Cells</span> dialog as well as the formatting of the cell contents</p>
</td>
</tr>
</table>
<br>
</div>
<div class="search-frame"></div>
<div class="donation-frame"></div>
<footer><div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p>This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/shared/guide/paintbrush.xhp" target="_blank">/text/shared/guide/paintbrush.xhp</a></p>
<p>Title is: Copying Attributes With the Clone Formatting Tool</p>
<p id="bm_module"></p>
<p id="bm_system"></p>
<p id="bm_HID"></p>
</div></footer>
</body>
</html>
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| aaa_start.html | File | 5.31 KB | 0644 |
|
| accessibility.html | File | 6.79 KB | 0644 |
|
| active_help_on_off.html | File | 4.71 KB | 0644 |
|
| activex.html | File | 6.61 KB | 0644 |
|
| assistive.html | File | 6.03 KB | 0644 |
|
| autocorr_url.html | File | 6.18 KB | 0644 |
|
| autohide.html | File | 6.12 KB | 0644 |
|
| background.html | File | 4.91 KB | 0644 |
|
| border_paragraph.html | File | 6.5 KB | 0644 |
|
| border_table.html | File | 6.31 KB | 0644 |
|
| breaking_lines.html | File | 5.77 KB | 0644 |
|
| change_title.html | File | 3.94 KB | 0644 |
|
| chart_axis.html | File | 4.43 KB | 0644 |
|
| chart_barformat.html | File | 4.55 KB | 0644 |
|
| chart_insert.html | File | 7.74 KB | 0644 |
|
| chart_legend.html | File | 4.56 KB | 0644 |
|
| chart_title.html | File | 4.81 KB | 0644 |
|
| cmis-remote-files-setup.html | File | 15.45 KB | 0644 |
|
| cmis-remote-files.html | File | 10.95 KB | 0644 |
|
| collab.html | File | 10.86 KB | 0644 |
|
| configure_overview.html | File | 3.87 KB | 0644 |
|
| contextmenu.html | File | 4.25 KB | 0644 |
|
| convertfilters.html | File | 99.45 KB | 0644 |
|
| copy_drawfunctions.html | File | 5.4 KB | 0644 |
|
| copytable2application.html | File | 5.26 KB | 0644 |
|
| copytext2application.html | File | 6.4 KB | 0644 |
|
| ctl.html | File | 7.04 KB | 0644 |
|
| data_addressbook.html | File | 7.1 KB | 0644 |
|
| data_dbase2office.html | File | 6.26 KB | 0644 |
|
| data_enter_sql.html | File | 5.73 KB | 0644 |
|
| data_forms.html | File | 5.44 KB | 0644 |
|
| data_im_export.html | File | 8.61 KB | 0644 |
|
| data_new.html | File | 3.96 KB | 0644 |
|
| data_queries.html | File | 5.15 KB | 0644 |
|
| data_register.html | File | 5.12 KB | 0644 |
|
| data_report.html | File | 5.98 KB | 0644 |
|
| data_reports.html | File | 8.39 KB | 0644 |
|
| data_search.html | File | 4.14 KB | 0644 |
|
| data_search2.html | File | 6.88 KB | 0644 |
|
| data_tabledefine.html | File | 6.38 KB | 0644 |
|
| data_tables.html | File | 5.87 KB | 0644 |
|
| data_view.html | File | 4.31 KB | 0644 |
|
| database_main.html | File | 6.27 KB | 0644 |
|
| digital_signatures.html | File | 12.88 KB | 0644 |
|
| digitalsign_receive.html | File | 6.7 KB | 0644 |
|
| digitalsign_send.html | File | 11.1 KB | 0644 |
|
| doc_autosave.html | File | 6.99 KB | 0644 |
|
| doc_open.html | File | 6.83 KB | 0644 |
|
| doc_save.html | File | 8.43 KB | 0644 |
|
| dragdrop.html | File | 7.72 KB | 0644 |
|
| dragdrop_beamer.html | File | 7.92 KB | 0644 |
|
| dragdrop_fromgallery.html | File | 5.91 KB | 0644 |
|
| dragdrop_gallery.html | File | 5.83 KB | 0644 |
|
| dragdrop_graphic.html | File | 5.87 KB | 0644 |
|
| dragdrop_table.html | File | 5.78 KB | 0644 |
|
| edit_symbolbar.html | File | 4.68 KB | 0644 |
|
| email.html | File | 5.23 KB | 0644 |
|
| error_report.html | File | 5.61 KB | 0644 |
|
| export_ms.html | File | 5.05 KB | 0644 |
|
| fax.html | File | 5.8 KB | 0644 |
|
| filternavigator.html | File | 5.74 KB | 0644 |
|
| find_attributes.html | File | 6.98 KB | 0644 |
|
| flat_icons.html | File | 3.97 KB | 0644 |
|
| floating_toolbar.html | File | 7.85 KB | 0644 |
|
| fontwork.html | File | 7.77 KB | 0644 |
|
| formfields.html | File | 6 KB | 0644 |
|
| gallery_insert.html | File | 7.42 KB | 0644 |
|
| groups.html | File | 7.37 KB | 0644 |
|
| hyperlink_edit.html | File | 6.77 KB | 0644 |
|
| hyperlink_insert.html | File | 5.46 KB | 0644 |
|
| hyperlink_rel_abs.html | File | 7.91 KB | 0644 |
|
| imagemap.html | File | 9.78 KB | 0644 |
|
| import_ms.html | File | 8.25 KB | 0644 |
|
| insert_bitmap.html | File | 11.56 KB | 0644 |
|
| insert_graphic_drawit.html | File | 10.96 KB | 0644 |
|
| insert_specialchar.html | File | 6.28 KB | 0644 |
|
| integratinguno.html | File | 4.58 KB | 0644 |
|
| keyboard.html | File | 31.7 KB | 0644 |
|
| labels.html | File | 6.7 KB | 0644 |
|
| labels_database.html | File | 5.81 KB | 0644 |
|
| language_select.html | File | 14.54 KB | 0644 |
|
| line_intext.html | File | 8.89 KB | 0644 |
|
| lineend_define.html | File | 4.41 KB | 0644 |
|
| linestyle_define.html | File | 4.92 KB | 0644 |
|
| linestyles.html | File | 4.55 KB | 0644 |
|
| macro_recording.html | File | 7.35 KB | 0644 |
|
| main.html | File | 25.28 KB | 0644 |
|
| measurement_units.html | File | 4.93 KB | 0644 |
|
| microsoft_terms.html | File | 9.26 KB | 0644 |
|
| ms_doctypes.html | File | 4.69 KB | 0644 |
|
| ms_import_export_limitations.html | File | 10.31 KB | 0644 |
|
| ms_user.html | File | 11.12 KB | 0644 |
|
| navigator.html | File | 5.57 KB | 0644 |
|
| navigator_setcursor.html | File | 4.96 KB | 0644 |
|
| navpane_on.html | File | 3.84 KB | 0644 |
|
| numbering_stop.html | File | 7.71 KB | 0644 |
|
| openpgp.html | File | 11.68 KB | 0644 |
|
| pageformat_max.html | File | 4.68 KB | 0644 |
|
| paintbrush.html | File | 10.44 KB | 0644 |
|
| pasting.html | File | 5.69 KB | 0644 |
|
| print_blackwhite.html | File | 9.01 KB | 0644 |
|
| print_faster.html | File | 5.37 KB | 0644 |
|
| protection.html | File | 10.75 KB | 0644 |
|
| qrcode.html | File | 5.39 KB | 0644 |
|
| redaction.html | File | 8.97 KB | 0644 |
|
| redlining.html | File | 6.25 KB | 0644 |
|
| redlining_accept.html | File | 6.44 KB | 0644 |
|
| redlining_doccompare.html | File | 6.25 KB | 0644 |
|
| redlining_docmerge.html | File | 5.57 KB | 0644 |
|
| redlining_enter.html | File | 8.31 KB | 0644 |
|
| redlining_navigation.html | File | 5.28 KB | 0644 |
|
| redlining_protect.html | File | 5.26 KB | 0644 |
|
| redlining_versions.html | File | 4.81 KB | 0644 |
|
| round_corner.html | File | 4.41 KB | 0644 |
|
| scripting.html | File | 13.38 KB | 0644 |
|
| space_hyphen.html | File | 6.35 KB | 0644 |
|
| spadmin.html | File | 6.68 KB | 0644 |
|
| standard_template.html | File | 6.98 KB | 0644 |
|
| start_parameters.html | File | 37.53 KB | 0644 |
|
| startcenter.html | File | 8.41 KB | 0644 |
|
| tabs.html | File | 10.75 KB | 0644 |
|
| template_manager.html | File | 16.63 KB | 0644 |
|
| text_color.html | File | 5.28 KB | 0644 |
|
| textmode_change.html | File | 4.52 KB | 0644 |
|
| undo_formatting.html | File | 5.66 KB | 0644 |
|
| version_number.html | File | 3.6 KB | 0644 |
|
| viewing_file_properties.html | File | 4.65 KB | 0644 |
|
| workfolder.html | File | 4.9 KB | 0644 |
|
| xforms.html | File | 5.95 KB | 0644 |
|
| xsltfilter.html | File | 6.45 KB | 0644 |
|
| xsltfilter_create.html | File | 9.73 KB | 0644 |
|
| xsltfilter_distribute.html | File | 5.25 KB | 0644 |
|