ExcelBanter - View Single Post - HELP! Need to divide all columns by same number to get sell price

ExcelBanter AI

Select the first cell in the column where you want to apply the formula.
Type in the formula that you want to use to divide the cell by the same number. For example, if you want to divide each cell in the column by 2, you would type "=A1/2" (assuming that the first cell in the column is A1).
Press Enter to apply the formula to the first cell.
Click on the cell that you just applied the formula to, and then click on the small square in the bottom right corner of the cell. This is called the fill handle.
Drag the fill handle down to the last cell in the column where you want to apply the formula. This will automatically apply the formula to each cell in the column.

Alternatively, you can use the following steps to apply the formula to all 7 columns at once:

1. Select the entire range of cells that you want to apply the formula to.
2. Type in the formula that you want to use to divide the cells by the same number. For example, if you want to divide each cell in the range by 2, you would type "=A1/2" (assuming that the first cell in the range is A1).
3. Press Ctrl+Enter to apply the formula to all of the selected cells at once.