How to Copy only the Formula and not the color of the cell?

Last Updated on 27/02/2024
Reading time: 2 minutes

There are 3 ways to copy only your formulas and not the color of your cells when you do a copy-paste

  1. Paste-Special Formula

    This is the most used technique. After copying the cell, you paste it with this option

  2. The fill handle and then use the options

    When you use the fill handle, you have paste options when you release the button of the mouse

  3. The fill handle with the right-click

    You can use the fill handle with the right-click of the mouse to display options

What is the problem with the copy-paste?

When you copy a cell with a value or a formula, you copy the content AND the formatting.

Format destroyed with copy paste

Sure, you have copied the formulas but also the formatting of the source cell

#1: Copy Paste Special - Formula

The paste special tool technique allows you to paste only one element of your source, such as formulae, formatting, comments, column width, ....

  1. Start by copying your cells (here F2) with the keyboard shortcut Ctrl + C
  2. Select the cells where to paste these formulas
  3. Click on the icon Home > Paste > Formula

Just like that, only the formula is copied

Copy only the formula from the ribbon

#2: Options with the fill-handle

Now, we will use the fill-handle but we will correct the error seen in the first paragraph.

  1. When you release the mouse button, the formatting is overwritten (initial situation).
  2. But, maybe you don't have the tooltip option that appears at the end of your selection
  3. When you click on this icon, you see different paste options
Detail of the fill handle options
  1. Select the option Fill Without Formatting
  2. Only formulas are copied with the fill-handle
Animation copy only formula with fill handle option

#3: The fill-handle with the right-click

  1. Select the cell to copy
  2. Use the fill handle to extend your selection but use the right button of the mouse
  3. When you release the button of the mouse, you display more options
  4. Here again, you select Fill Without Formatting
  5. Only formulas are copied and not the formatting
Right Clic with Fill Handle

Leave a Reply

Your email address will not be published. Required fields are marked *

How to Copy only the Formula and not the color of the cell?

Reading time: 2 minutes
Last Updated on 27/02/2024

There are 3 ways to copy only your formulas and not the color of your cells when you do a copy-paste

  1. Paste-Special Formula

    This is the most used technique. After copying the cell, you paste it with this option

  2. The fill handle and then use the options

    When you use the fill handle, you have paste options when you release the button of the mouse

  3. The fill handle with the right-click

    You can use the fill handle with the right-click of the mouse to display options

What is the problem with the copy-paste?

When you copy a cell with a value or a formula, you copy the content AND the formatting.

Format destroyed with copy paste

Sure, you have copied the formulas but also the formatting of the source cell

#1: Copy Paste Special - Formula

The paste special tool technique allows you to paste only one element of your source, such as formulae, formatting, comments, column width, ....

  1. Start by copying your cells (here F2) with the keyboard shortcut Ctrl + C
  2. Select the cells where to paste these formulas
  3. Click on the icon Home > Paste > Formula

Just like that, only the formula is copied

Copy only the formula from the ribbon

#2: Options with the fill-handle

Now, we will use the fill-handle but we will correct the error seen in the first paragraph.

  1. When you release the mouse button, the formatting is overwritten (initial situation).
  2. But, maybe you don't have the tooltip option that appears at the end of your selection
  3. When you click on this icon, you see different paste options
Detail of the fill handle options
  1. Select the option Fill Without Formatting
  2. Only formulas are copied with the fill-handle
Animation copy only formula with fill handle option

#3: The fill-handle with the right-click

  1. Select the cell to copy
  2. Use the fill handle to extend your selection but use the right button of the mouse
  3. When you release the button of the mouse, you display more options
  4. Here again, you select Fill Without Formatting
  5. Only formulas are copied and not the formatting
Right Clic with Fill Handle

Leave a Reply

Your email address will not be published. Required fields are marked *