Copy and paste formatting rules
Depending on the selected element, you can format:
- Paragraph
- Text
- Paragraph and text
- Cell
The table below shows the principles according to which formatting is copied and pasted.
| When you copy | When you paste | Result |
|---|---|---|
| The cursor is positioned or the entire paragraph (paragraphs) is/are selected | The cursor is positioned | Formatting of a paragraph or first selected paragraph |
| The cursor is positioned or the entire paragraph (paragraphs) is/are selected | A paragraph is partially selected | Text formatting |
| The cursor is positioned or the entire paragraph (paragraphs) is/are selected | The entire paragraph or paragraphs is/are selected | Text formatting |
| The cursor is positioned or the entire paragraph (paragraphs) is/are selected | Several paragraphs are partially selected | Text formatting |
| A part of the paragraph is selected | The cursor is positioned | Formatting is not pasted |
| A part of the paragraph is selected | A part of the paragraph is selected | Formatting selected text |
| A part of the paragraph is selected | The entire paragraph or paragraphs is/are selected | Formatting selected text |
| A part of the paragraph is selected | Several paragraphs are partially selected | Formatting selected text |
| The cursor is positioned | A spreadsheet cell, column, or row is selected | Formatting of text and paragraph for the selected cell |
| A part of the paragraph is selected | A spreadsheet cell, column, or row is selected | Formatting of text for a selected cell |
| The entire paragraph or paragraphs is/are selected | A spreadsheet cell, column, or row is selected | Formatting of a paragraph and text |
| A cell is selected or the active cell of the selected range is selected | A spreadsheet cell is selected | Formatting of a cell, paragraph, and text |
| A cell is selected or the active cell of the selected range is selected | The cursor is positioned | Formatting of a paragraph |
| A cell is selected or the active cell of the selected range is selected | A part of the paragraph is selected | Text formatting |
| A cell is selected or the active cell of the selected range is selected | The entire paragraph or paragraphs is/are selected | Formatting of a paragraph and text |
| A cell is selected or the active cell of the selected range is selected | Several paragraphs are partially selected | Formatting of a paragraph |
| A cell is selected or the active cell of the selected range is selected | A row or column is selected |
|
| A row or column is selected | A row or column is selected |
|