Where is the autofill button on excel?

Anonymous
2025-06-11T16:58:10+00:00

I've been away from spreadsheets for ages. I'm supposed to find the autofill button on excel (M365). All I've been asking is where is that stupid button. Could someone please just tell me where to find it?

Microsoft 365 and Office | Excel | For education | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2025-06-11T17:27:38+00:00

    Scratch that. I found it. Thanks, Boss. I should have read it a bit more closely. Huge props.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-06-11T17:25:32+00:00

    I've done that several times. I simply cannot find the button. Is it on the toolbar, or am i supposed to be doing something else? This is for a college class assignment, (returning student), and I'm trying to figure this out.

    Was this answer helpful?

    0 comments
  3. HansV 462.7K Reputation points MVP Volunteer Moderator
    2025-06-11T17:18:06+00:00

    First, select File > Options > Advanced.

    Make sure that the check box 'Enable fill handle and cell drag-and-drop' in the Editing options section is selected.

    Enter something in one or two cells, then use the fill handle in the lower right corner of the selection to drag down or to the right.

    When you release the mouse button, the AutoFill Options button should appear.

    See Fill data automatically in worksheet cells

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments