I want to divide column A by column B and column C should show the answer. I don't want to type =A1/B1 for each cell. How can I do it all at one time?
2007-02-06 08:51:12 · 2 answers · asked by cashmaker81 6 in Computers & Internet ➔ Other - Computers
Type the formula in once, and then copy it to the rest of the column by moving your mouse to the bottom right corner of the cell. It will turn into a + sign. Left-click and drag it down the column and it will copy the formula.
2007-02-06 08:56:35 · answer #1 · answered by wyntre_2000 5 · 0⤊ 0⤋
hi; One occasion I created replaced into when I made a spreadsheet that had one sheet for uncooked archives and then used different sheets to reveal the suggestions and graphs for persons to view. yet another occasion could be to have each month have its own sheet and then have the suggestions displayed in a 300 and sixty 5 days end synopsis. I made a spreadsheet that had one section for coaching easy arithmetic equations and yet another sheet for coaching fractions, and a third sheet that dealt with coaching some geometry recommendations. wish that facilitates, bill
2016-12-17 03:59:28 · answer #2 · answered by binford 4 · 0⤊ 0⤋