If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

Drag the Fill Handle across all the cells in the row you want to fill with the formula. Click the "AutoFill Options" button to select your options for how you want the cells automatically filled.

You can use the formula [=A2*0.1] in cell B2 and drag the formula down the entire B column. Excel will automatically adjust the references to A3, A4, and so on.

1] How to subtract multiple cells in Excel by using a formula Here we will talk about how to subtract data arranged in multiple cells in a particular row and column from a single cell in Excel.

How to Change the Height & Width of Cells in Excel. Upon launching Microsoft Excel, an exactly-formatted spreadsheet grid is presented for you to start filling in.