Skip to main content

Copy, clear formatting

You can quickly copy formatting (font, color, size, paragraph alignment, etc.) from one part of a file and apply it to another part of the same file or another application.

For text in a cell, you can copy parameters such as font, size, and text color.

For the cell itself, you can copy parameters such as alignment, fill color, and borders.

Copy and apply formatting using hotkeys​

  1. Select the text or cell with the desired formatting.
  2. Press Ctrl+Shift+C (Cmd+Shift+C). The formatting will be copied.
  3. Select the text, cell, or range of cells to which you want to apply the formatting.
  4. Press Ctrl+Shift+V (Cmd+Shift+V). The formatting will be applied.

Copy and apply formatting using the toolbar​

  1. Select the text or cell with the desired formatting.
  2. Click the Copy formatting button on the Home tab, in the Edit group. The formatting will be copied and the cursor will change to a paintbrush.
  3. Select the text, cell, or range of cells to which you want to apply the formatting. The formatting will be applied immediately.

Copy and apply formatting to non-adjacent fragments​

  1. Double-click the Copy formatting button. It will remain active.
  2. Apply the formatting to the desired content in sequence.
  3. To exit the mode, click the button again or press the Esc key.

Clear formatting​

  1. Select a cell or range of cells.
  2. Press Ctrl+Space (Cmd+Space).

You can also use the Clear formatting tool in the context menu or on the Home tab, in the Edit group.