1. Click on cell A3 to select it. This is the cell that contains the date you want to copy.

2. Move your cursor to the bottom right corner of the cell until it changes to a small black cross. This is called the "fill handle."

3. Click and hold the left mouse button on the fill handle, then drag it down to the cells where you want to copy the date. As you drag, you'll see a preview of the data being copied.

4. Release the mouse button to drop the date into the cells. The date from cell A3 should now be copied into all the cells you selected.

Remember, this method will copy the exact date, it won't increment the date for each row. If you want to increment the date, you'll need to use a different method.

Question

1. Click on cell A3 to select it. This is the cell that contains the date you want to copy.

2. Move your cursor to the bottom right corner of the cell until it changes to a small black cross. This is called the "fill handle."

3. Click and hold the left mouse button on the fill handle, then drag it down to the cells where you want to copy the date. As you drag, you'll see a preview of the data being copied.

4. Release the mouse button to drop the date into the cells. The date from cell A3 should now be copied into all the cells you selected.

Remember, this method will copy the exact date, it won't increment the date for each row. If you want to increment the date, you'll need to use a different method.

Knowee AI · Accepted Answer

1. Click on cell A3 to select it. This is the cell that contains the date you want to copy.

2. Move your cursor to the bottom right corner of the cell until it changes to a small black cross. This is called the "fill handle."

3. Click and hold the left mouse button on the fill handle, then drag it down to the cells where you want to copy the date. As you drag, you'll see a preview of the data being copied.

4. Release the mouse button to drop the date into the cells. The date from cell A3 should now be copied into all the cells you selected.

Remember, this method will copy the exact date, it won't increment the date for each row. If you want to increment the date, you'll need to use a different method.

What's the fastest way to copy a specific date, say 2/7/2021 in cell A3, down into other cells immediately below it in the same column?

Question

What's the fastest way to copy a specific date, say `2/7/2021` in cell `A3`, down into other cells immediately below it in the same column?

Solution

Similar Questions

Upgrade your grade with Knowee