How to Auto Fill Down in Excel for Mac

Auto Fill is a powerful feature in Excel that enables you to quickly populate rows or columns with a variety of data types, including:

  • The same value or string
  • An incremented value
  • A decremented value
  • A value calculated using a formula

Let's see examples of each of them,

1. Auto Fill same value or string

Auto Fill Same Value or String in Excel

As you may see in the above example, in column A we have a number, and in column B we have a string name Sam.

You can keep taking your cursor to the bottom left side of the cell and the + sign cursor appears, hold on your mouse, and drag down until the cell you want the value to be repeated.

Or, you can also make use of the keyboard shortcut Control + D on your Mac to fill in all the selected columns.

2. Auto Fill Increment values

Auto Fill increment value in Excel

This is one of the most valuable scenarios, fill in a few values and drag the + pointer till the cell you want the values to be filled. As in the above example 1, 2, 3, 4... 10

3. Auto Fill Decrement values

Auto Fill decrement value in Excel

Here you will fill few values in descending order eg 10, 9, and use + pointer to fill the rest of the required cells.

4. A value calculated using a formula

Auto Fill based on formula in Excel

Let's say you have numbers 1 to 10 in column A, and in column C, repeated value 2, in cell D2 you have the formula = A2*C2

Now all you need to do is, click on the + cursor and drag to apply the formula in column D

Note: You can also double-click on the + pointer and the rest of the down cells will be auto-filled.

Facing issues? Have Questions? Post them here! I am happy to answer!

Author Info:

Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail:

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap