Here’s a Neat Excel Trick for Pasting Formulas


excelMany Excel worksheets have columns and rows of identical formulas that have different formatting throughout. Now, when you edit a formula and want to copy it down your column or across your row, but don’t want to over-ride the formatting of the other cells, you would normally use a right-click and select Copy, select the cells where you would like to paste and right-click and select Paste Special | Formulas.

Guess what?? There are quicker, easier methods to achieve the same outcome:

Start with the cell containing the formula you would like to copy.

  1. Select the cells where you would like to paste the formulas.
  2. Notice that the formula you would like to copy is in the active cell.
  3. Click F2 and you will be in edit mode.
  4. Click CTRL + Enter and your formula has been copied down without affecting formatting in other cells.

But wait! There’s more! There is another method.

Follow the steps below to learn how:

  1. Point to the Fill Handle at the right-hand bottom corner of the cell you would like to copy.
  2. Depress your right mouse button and drag down your column.
  3. When you release your mouse button, select Fill Without Formatting.
  4. Your formula has now been filled down to all of the cells without affecting your formatting.
Posted in:
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.

There are 3 comments

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