All courses available in-class and remotely.

Autofill in excel is a massive time saver when dealing with lots of data at once.

When a cell is selected, a small green square will appear in the bottom right-hand corner. This is the fill handle. When you hover over this, a black cross appears.

When clicked and dragged across cells in your spreadsheet, the formula in the original box will be replicated in the boxes next to it. If there is no formula, the value in the cell will be replicated instead.

excel autofill

autofill excel

Double clicking the fill handle will autofill down to the last row of data on the left of the current column. The result will be a complete list with all the data.

Nexacu is a leader in training excel. Our Microsoft excel training courses will help you take your skills to another level. 

Related Topics

Contact Us

What is Remote Training?

Valued by Individuals

4.72 / 5
Over 39832 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us