Excel - Excel Tutorial: Copy Formulas Easily with This Clever Trick | MrExcel Netcast - Episode 545
Hellow guys, Welcome to my website, and you are watching Excel - Excel Tutorial: Copy Formulas Easily with This Clever Trick | MrExcel Netcast - Episode 545. and this vIdeo is uploaded by MrExcel.com at 2009-07-29T10:39:08-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
Info About This Video
Name |
Excel - Excel Tutorial: Copy Formulas Easily with This Clever Trick | MrExcel Netcast - Episode 545 |
Video Uploader |
Video From MrExcel.com |
Upload Date |
This Video Uploaded At 29-07-2009 17:39:08 |
Video Discription |
Microsoft Excel Tutorial: Copy Formulas Easily with This Clever Trick.
Welcome back to the MrExcel netcast! In today's video, I'll be sharing a helpful tip from one of our viewers, Suzanne in Chicago. I had the pleasure of meeting Suzanne at one of my Power Excel seminars and I'm excited to share her tip with all of you.
Before we dive into the tip, I wanted to let you know that we have a jam-packed schedule of seminars for the fall. Our biggest event is the Data Analyst Boot Camp in Chicago from September 18th to the 20th. This three-day seminar, hosted by myself and Mike Alexander, covers everything you need to know about Excel and Access. It's a fantastic opportunity for anyone interested in these programs. We also have half-day seminars scheduled in Birmingham, Milwaukee, Madison, Springfield, and we're working on adding Boise to the list. Plus, we have a couple of hour and a half breakout sessions in Virginia Beach and Roanoke. If you're interested in attending any of these seminars, just head to the home page of MrExcel and click on the "Upcoming Seminars" link. And if you're part of an accounting group or a large company with 30 to 50 people, I'd love to come out and do a seminar for your group.
Now, onto the tip! As many of you know, my favorite trick in Excel is using the double-click fill handle to copy a formula down a column. However, this trick only works if the column to the left is filled with data. But what if you have a sparsely populated column to the left, like an apartment or suite number? That's where this tip comes in handy.
To ensure that the double-click fill handle trick works, simply hide the column to the left. Excel will then rely on the column that is two columns to the left. So if we have a formula in column D, we can hide column C and double-click the fill handle to copy the formula down. Once we're done, we can unhide the column and our data will be complete.
Alternatively, if you have data to the right of the column you want to copy, you can insert a blank column between the two. This will also allow the double-click fill handle trick to work, as Excel will now rely on the column to the right. Whichever method you choose, it will save you time and prevent the need for the "fill handle dance" where you drag the fill handle back and forth to copy the formula.
Thanks for watching this MrExcel netcast! Don't forget to subscribe to our channel for more helpful tips and tricks. See you next time!
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-on-youtube/
My favorite trick is to double click the fill handle to copy a formula. But, this requires the column to the left to have no blanks cells. Today, Suzanne from Chicago gives us a great trick of how to overcome a sparse column to the left of the formula. Episode 545 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Table of Contents:
(00:00) Introduction and upcoming seminars
(00:25) Data analyst boot camp in Chicago
(00:35) Half-day seminars in various cities
(00:53) Request for seminars in other cities
(01:11) Excel tip: copying formulas using the fill handle
(01:50) Alternative method for copying formulas using hidden columns
(02:18) Another alternative method using inserted columns
(02:52) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
Birmingham Alabama
Chicago
Data analyst boot camp
Excel and Access
Excel formula copy trick
Madison Wisconsin
Milwaukee Wisconsin
MrExcel netcast
Power Excel seminars
Seminar schedule
Springfield Illinois
Springfield Missouri
Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152541/ |
Category |
Education |
Tags |
Excel | business | accounting | spreadsheets | tutorial | technology | MrExcel | shortcuts | format | mrexcel channel | mrexcel website | mrexcel forum | Formula | Bill Jelen | Learn Excel | Excel Tutorial | Power Excel | Microsoft Excel | Excel Tips | Data Set | Excel Help | Learn Excel with MrExcel | Excel Tips and Tricks | MrExcel Podcast |
More Videos