MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Fill without Formatting


October 26, 2017 - by Bill Jelen

Fill without Formatting

Fill without Formatting. Sometimes you need to copy a formula but not screw up the existing formatting. Learn how with this article.

Watch Video

  • You need to copy formulas but not screw up the formatting in cells
  • My Method: Ctrl + C to copy, Paste Special, Formulas, OK
  • Adam in Raleigh: Right-drag the formulas, choose Fill without Formatting

Video Transcript

Learn Excel from MrExcel, Podcast Episode 2163: Fill Without Formatting.

Hey. Welcome back to the MrExcel netcast. I'm Bill Jelen. I was up in Raleigh the other day doing a seminar and I had to copy these formulas down but not screw up the formatting design that was there. So, I did CONROL+C and then select this range and edit, PASTE SPECIAL, that's ALT+E S, choose FORMULA, so ALT+E, S, F, ENTER, and one of the people in the class, Adam, says, “Wait, Why’d you do all that? You can just select the data and right drag, right drag, and when you let go, there's a choice that says FILL WITHOUT FORMATTING. That'll copy those formulas down and keep the original formatting.” Much, much easier way to go.

Alright, so, Power Excel With MrExcel, the 2017 Edition, 617 Excel Mysteries Solved. Well, now I have 618, thanks to Adam, but you can buy all 617 of these. Click that i on the top right-hand corner.

Easy one today: you need to copy the formulas but not screw up the formatting in the cells; my method, CONTROL+C, ALT+E, S, F, ENTER; or Adam, just right-drag the formulas and then, when you let go, choose FILL WITHOUT FORMATTING.

I want to thank you for stopping by. We'll see you next time for another netcast from MrExcel.

Download File

Download the sample file here: Podcast2163.xlsm

Title Photo: andreas160578 / Pixabay


Bill Jelen is the author / co-author of
MrExcel LIVe

A book for people who use Excel 40+ hours per week. Illustrated in full color.