Copy and apply formatting

Product: MyOffice Professional, MyOffice Education

Application: Spreadsheet Desktop version

In MyOffice Spreadsheet, you can copy the formatting from a part of a document to another. The formatting copied can be applied to:

•Once: To one fragment of the document.

•Multiple times: To several document fragments in succession.

The formatting copied to the clipboard can also be used in MyOffice Text.

Formatting basics

Depending on the selected element, you can format:

•Paragraph

•Text

•Paragraph and text

•Cell

The table below specifies how the formatting is copied and applied:

When you copy	When you insert	Result
The cursor is positioned or the entire paragraph (paragraphs) is selected	The cursor is positioned	Formats the paragraph or the first selected paragraph
	A paragraph is partially selected	Formats the text
	The entire paragraph or paragraphs are selected	Formats the paragraph and text
	Several paragraphs are partially selected	Formats the paragraph
A paragraph is partially selected	The cursor is positioned	No formatting
	A paragraph is partially selected	Formats the text from the first selected character
	The entire paragraph (paragraphs) is selected
	Several paragraphs are partially selected
The cursor is positioned	A spreadsheet cell is selected	Formats the paragraph and text in the selected cell
A paragraph is partially selected		Formats the text in the selected cell
The entire paragraph (paragraphs) is selected (up to the paragraph sign)		Formats the paragraph and text
A spreadsheet cell is selected	A spreadsheet cell is selected	Formats the cell, paragraph, and text
	The cursor is positioned	Formats the paragraph
	A paragraph is partially selected	Formats the text
	The entire paragraph (paragraphs) is selected	Formats the paragraph and text
	Several paragraphs are partially selected	Formats the paragraph
A row or column is selected	A row or column is selected	Formats the cell, paragraph, and text
A row or column is selected	A row or column is selected	•Formats the cell, paragraph, and text from the upper left cell in the copied row or column •Formats the row or column

Copy and apply formatting

To copy and paste formatting you can use the following tools:

•The t_edit_copy_formatting Copy formatting button on the Toolbar.

•Keyboard shortcuts.

•Command menu options (when working in macOS).

To format one element of a document using the t_edit_copy_formatting Copy formatting button, follow these steps:

1.Select the part of the document you want to copy the formatting from (see the Formatting basics section).

2.On the Home tab, in the Edit group, click t_edit_copy_formatting Copy formatting.

3.Select the part of the document you want to copy the formatting to (see the Formatting basics section).

To format multiple elements of a document using the t_edit_copy_formatting Copy formatting button, follow these steps:

1.Select the part of the document you want to copy the formatting from (see the Formatting basics section).

2.On the Home tab, in the Edit group, double-click t_edit_copy_formatting Copy formatting to make it look like t_edit_multiple_copy_formatting .

3.Format the desired parts of the document one by one as described in the section above.

To exit the multiple elements formatting mode, use one of the following methods:

•On the Home tab, in the Edit group, click the t_edit_multiple_copy_formatting button to make it look like t_edit_copy_formatting .

•Press Esc.

To copy the formatting using the command menu or keyboard shortcuts, follow these steps:

1.Select the part of the document you want to copy the formatting from (see the Formatting basics section).

2.When working in Windows or Linux, press Ctrl+Shift+C. When working in macOS, run the Edit > Copy formatting command from the command menu or press shift Shift+ command Cmd+C.

3.To apply the formatting to one part of the document, do the following:

•Select the part of the document you want to copy the formatting from (see the Formatting basics section).

•When working in Windows or Linux, press Ctrl+Shift+V. When working in macOS, run Edit > Paste formatting command from the command menu or press shift Shift+ command Cmd+V (macOS).

4.To apply the formatting to multiple elements in the document, select these elements one by one and apply the formatting as described above.

Formatting history

The formatting copied to the clipboard history is saved and can be applied later.

To open the formatting history, follow these steps:

1.On the Home tab, in the Edit group, click the arrow to the right of the t_edit_copy_formatting Copy formatting button.

2.In the opened drop-down list, select the format you want. The most recent formatting is on the top of the list.

3.Select the part of the document you want to apply the formatting to as described in the section above.

Was this helpful?

Yes