The fill function can also be used to fill dates. The fill function understands the pattern and helps us continue it. Then it fills the next cells, A3(6), A4(8), A5(10) and so on. This is because we created an order with A1(2) and A2(4). It counts from 2 to 20 in the range A1:A10. When we entered ( 1) and ( 2) in the cells it was able to understand the pattern and that the next cell A3 should be ( 3). That is why it created copies when we had entered the value ( 1) in both cells,Īs it saw no pattern. The fill function understands the pattern typed in the cells and continues it for us. Remember to mark both the values (holding down shift) before you fill theĬongratulations! You have now counted from 1 to 10. We now have two different values in the cells A1(1) and A2(2). This is because the fill function assumes that we want to create copies as we had two of the same values in both the cells A1(1) and A2(1).Ĭhange the value of A2(1) to A2(2). What happened is that we got the same values as we did with copying. Remember to mark both values before you fill the range. Let's use the fill function from A1:A10 to see what happens. Now we have the same values in both A1 and A2. Lets type the value ( 1) into the cell A2, which is what we have in A1. This is different from the last example because this time we do not want to copy, but to count from 1 to 10.įirst we will show an example which does not work, then we will do a working one.
#Excel keyboard shortcut for filling down how to#
Let's start with learning how to count from 1 to 10. Sequences can for example be used on numbers and dates.
We can use the filling function to continue the order that has been set. Let's have a look at sequences.įilling can be used to create sequences. Now you have learned how to fill and to use it for copying both numbers and words. In this example we have typed A1(Hello World).įilling the range A1:A10 creates ten copies of "Hello World": In this example we have typed the value A1(1):įilling the range A1:A10 creates ten copies of
It can be used for both numbers and words. Let's look into how to copy with the fill function.įilling can be used for copying. In this example, cell A1 was selected and the range A1:A10 was marked. Once you hover over it your mouse pointer will change its icon to a thin cross.Ĭlick the fill icon and hold down the left mouse button, drag and mark the range that you want to cover. The fill icon is found in the button right corner of the cell and has the icon of a small square. We will cover that in a later chapter.įilling is done by selecting a cell, clicking the fill icon and selecting the range using drag and mark while holding the left mouse button down.
#Excel keyboard shortcut for filling down manual#
Filling makes your life easier and is used to fill ranges with values, so that you do not have to type manual entries.įor now, do not think of functions.