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
My Method: Ctrl+C to copy, Paste Special, Formulas, OK
Adam in Raleigh: Right-drag the formulas, choose Fill without Formatting
Transcript of the video:
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.
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.
