Copy and apply formatting

Product: MyOffice Professional, MyOffice Standard, 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

If you want to copy and apply formatting, use the following tools:

•Command menu

•Keyboard shortcuts

• t_edit_copy_formatting Copy Formatting button on the Toolbar

To copy the formatting using the Command menu or a keyboard shortcut:

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

2.Copy the formatting using one of the following methods:

•In the Edit menu, select Copy Formatting.

•Press Ctrl+Shift+C.

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

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

•In the Edit menu, select Paste Formatting or press Ctrl+Shift+V.

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

To format one element of a document using the t_edit_copy_formatting Copy Formatting button:

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

2.On the Toolbar, select the Edit section and 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:

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

2.On the Toolbar, select the Edit section and double-click t_edit_copy_formatting Copy Formatting. The button will change to 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, follow these steps:

•On the Toolbar, select the Edit section and select t_edit_multiple_copy_formatting . The button will change to t_edit_copy_formatting .

•Press Esc.

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 Toolbar, select the Edit section and 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