WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Fill Down

Excel Fill Down

Excel fill down is an option when we want to fill down or copy any data or formulas to the cells down below, we can use the keyboard shortcut which is CTRL + D while copying the data and selecting the cells or we can click the fill button in the Home tab and use the option for fill down from the list.

What is Fill Down in Excel?

In all the software’s use of copy and paste, methods are invaluable. Probably the Ctrl + C and Ctrl + V are the universal shortcut keys everyone knows. Excel is no different from other software’s. In excel also copy & paste works the same way. Apart from copy and paste the formulas to below cells, in excel we can use the option FILL DOWN (Ctrl + D) as well.

Filling down the above cell value to below cells not necessarily requires the traditional copy and paste method. We can use the option of fill handle or Ctrl + D shortcut key.

Ctrl + D is nothing but Fill Down. It will fill down in excel the above cell value to the below-selected cells.

Fill Down in Excel

Excel Fill Down Shortcut

As I told Copy & Paste are the traditional method to have values in other cells. But in excel we can use a different techniques to handle this.

Fill Down Shortcut Key

Note: CTRL + D can only fill only values to below cells, not to any other cells.

You can download this Fill Down Excel Template here – Fill Down Excel Template

For example look at the below example data.

Fill Down Example 1

Now I want to total add the total column. Let’s apply the simple formula in cell C2.

Fill Down Example 1-1

Traditionally we use copy and paste the formula to below cells to have a formula applied for all the below cells. But place a cursor on the right bottom end of the formula cell.

Fill Down Example 1-2

Double click on the FILL HANDLE it will fill the current cell formula to all the below cells.

Fill Down Example 1-3

How cool it is to fill the formula rather than using copy & paste.

Instead of using FILL HANDLE & Copy-Paste, we can use the excel fill down shortcut in excel Ctrl + D to fill down values from the above cell.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Step 1: Place a cursor on the C3 cell.

Fill Down Step 1

Step 2: Now press the shortcut key Ctrl + D. We will have the relative formula from the above cell.

Fill Down Step 2

Step 3: In order to fill all the cells. First, select the formula cell until the last cell of the data.

Fill Down Step 3

Step 4: Now press Ctrl + D it will fill the formula to all the selected cells.

Fill Down Step 4

Fill Blank Cells with Above Cell Value

This is one of the toughest challenges I have faced early on in my career. Before I tell you what was the challenge let me show you the data first.

step 1

In the above data, I was asked by my manager to fill down in excel the year to remaining cells until we find the other year i.e. I have to fill 2010 year from A3 cell to A6 cell.

This is the sample of the data but there was a huge amount of data I was needed to fill. To be very frank I spent 1 extra hour than my usual shit time to complete the task.

However, later I learned the technique to fill this void cells with the above cell value. Follow the below steps to apply the same logic.

Step 1: Select all the cells in the data range.

step 2

Step 2: Now press F5 key. You will see Go To window.

step 3

Step 3: Now press on Special.

step 4

Step 4: In the below Go To Special window, select Blanks.

step 5

It will select all the blank cells in the selected area.

step 6

Step 5: No do not move your cursor to select any cells. Rather press equal and give a link to the above cell.

step 7

Step 6: After giving a link to the above cell, do not simply press enter. You need to use different logic here. Instead of pressing enter, press ENTER key by holding CTRL-key.

It will fill the values the all the selected cells.

step 8

Wow!!! Amazing, after the first incident I have not extended my shift for these silly reasons.

I have moved on from CTRL + C to CTRL + D in Excel

Recently I have realized the benefit of CTRL + D while working with large excel files. In my daily job, I deal with 5 to 10 lakhs of rows of data every day. Often I require to fetch the data from one worksheet to another. I have to apply a variety of formulas to fetch the data from different workbooks.

When I copy and paste the formula to the cells, it was usually taking more than 10 minutes to complete the formula. Can you imagine what I was doing all these 10 minutes??

fill handle

I was just hitting my computer and almost begging my excel to finish the process the fast. I was totally frustrated by the fact that for every formula I have to wait for more than 10 minutes every time.

Later I have started to use the Excel FILL DOWN, CTRL + D to fill the formula down to below cells. I have realized that I was taking only 2 minutes not more than that.

So, I have moved on from Ctrl + C to Ctrl + D in excel.

Things to Remember While Fill Down in Excel

  • Ctrl + D can only fill down. Neither has it filled to the right or left.
  • Ctrl + Enter will fill the values to all the selected cells in the worksheet.
  • FILL Handle also fill down instead of dragging the formula.
  • Ctrl + D fill down and Ctrl + R fill right.

Recommended Articles

This has been a guide to Fill Down in Excel. Here we discuss the how-to Fill Blank Cells with Above Cell Value using Excel Fill down Shortcut along with practical examples and downloadable excel template. You may learn more about excel from the following articles –

  • VBA ISNULL Function
  • VBA LEN Function
  • MATCH Excel Formula
  • TRANSPOSE Function in Excel
10 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Fill Down Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More