Using the Fill command

The  Fill command offers a few fills that Auto Fill doesn't. 

1. On the Home tab, select ​​​​​​​  Fill in the Editing group and do one of the following: 

   1. Down, Right, Up, Left, fills the selected cells in the chosen direction.

   2. Series lets you set the direction, type, date units, step and stop values of the fill.

   3. Justify adjust the width of a block of text to selected columns.

2. Choose the setting to use and select OK.

For more info, see Fill data automatically in worksheet cells.

Tip: Use shortcuts Ctrl+D for down, and Ctrl+R for right. 

The  Fill command offers a few fills that Auto Fill doesn't. 

1. On the Home tab, select ​​​​​​​  Fill in the Editing group and do one of the following: 

   1. Down, Right, Up, Left, fills the selected cells in the chosen direction.

   2. Series lets you set the direction, type, date units, step and stop values of the fill.

   3. Justify adjust the width of a block of text to selected columns.

2. Choose the setting to use and select OK.

For more info, see Fill data automatically in worksheet cells.

Tip: Use shortcuts ⌘+D for down, and ⌘+R for right. 

The Fill command isn't currently supported in Excel for the web. You can, however, use Fill in the Excel desktop app.

• To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.

  

Don't have the Excel desktop app? Try or buy Microsoft 365.

Tip: To fill a formula , a series, or use Flash Fill, try Auto Fill. For more info, see Auto Fill cells.