Excel fill down shortcut key

Open excel, and we entered a formula in cell E to merge the strings in A1 and B1.

#We click to select cell E2.

Then use the ctrl d shortcut key on the keyboard to fill in the formula in the cell above.

But if you click to select cell E4 and then use ctrl d, the formula will not be filled because the cell above it has empty content and There is no formula.

If the entire column needs to be filled, we can use the mouse to operate and click to select cell E1 The small square in the lower right corner.

Then just pull it down.

The cells passed by will be filled with the formula used in the first cell.

For more Excel-related technical articles, please visit the Excel Tutorial column to learn!

The above is the detailed content of Excel fill down shortcut key. For more information, please follow other related articles on the PHP Chinese website!