Excel Filling Finesse - Copy and Paste without Formatting - Episode 2163
Microsoft Excel Tutorial: Copy Formulas but Not Change Formatting.
Welcome to another episode of the MrExcel netcast, where we bring you the best tips and tricks for mastering Excel. In today's episode, we will be discussing how to fill cells with formulas without messing up the existing formatting. This is a common issue that many Excel users face, but fear not, as we have the perfect solution for you.
During a recent seminar in Raleigh, I encountered a situation where I needed to copy formulas without changing the formatting. My initial method was to use CONTROL+C and then paste special with ALT+E S and choose FORMULA. However, one of the attendees, Adam, shared a much easier method with me. By simply selecting the data and right-dragging, you can choose the option "FILL WITHOUT FORMATTING" when you release the mouse. This will copy the formulas while preserving the original formatting.
This tip is just one of the 617 Excel mysteries solved in my book "Power Excel With MrExcel, the 2017 Edition". Thanks to Adam, we now have 618 mysteries solved! If you want to learn more tips and tricks like this, click the "i" on the top right-hand corner to purchase the book.
So, the next time you need to copy formulas without messing up the formatting, remember to use the right-drag method or the ALT+E S F shortcut. Thank you for tuning in to this episode of the MrExcel netcast. Don't forget to subscribe and hit the notification bell to stay updated on our latest videos. We'll see you next time for more Excel mastery.
Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-...
#excel
#microsoft
#microsoftexcel
#exceltips
#exceltricks
#excelformatting
This video answers these common search terms:
how to paste without formatting in excel
how to copy without formatting excel
how to copy without formatting in excel
how to fill without formatting excel
how to paste without format in excel
how to paste without formatting excel
how do you fill without formatting in excel
how do you paste without formatting in excel
how to fill rows without formatting in excel
how to fill range without formatting in excel
how to paste text without formatting in excel
how to paste without cell formatting in excel
where is the fill without formatting in excel
excel how to paste without format
how to copy formula without formatting excel
how to copy formula without formatting in excel
how to copy in excel without formatting
how to copy and paste without formatting in excel
how to copy and paste in excel without format
how to copy and paste a formula without formatting excel
Table of Contents:
(00:00) Copying Formulas Without Formatting
(00:20) Easy Method: CONTROL+C, ALT+E, S, F, ENTER
(00:30) FILL WITHOUT FORMATTING
(01:05) Clicking Like really helps the algorithm
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
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...
Watch video Excel Filling Finesse - Copy and Paste without Formatting - Episode 2163 online without registration, duration hours minute second in high quality. This video was added by user MrExcel.com 26 October 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 55,232 once and liked it 198 people.