Spreadsheet Formula Help - Classroom 2.02024-03-29T13:22:48Zhttps://www.classroom20.com/forum/topics/spreadsheet-formula-help?commentId=649749%3AComment%3A403226&feed=yes&xn_auth=noThanks!tag:www.classroom20.com,2009-11-09:649749:Comment:4032402009-11-09T15:21:49.562ZDarcie Priesterhttps://www.classroom20.com/profile/DarciePriester
Thanks!
Thanks! Dragging the handle down 100…tag:www.classroom20.com,2009-11-09:649749:Comment:4032262009-11-09T14:57:39.270ZBob Zenhausernhttps://www.classroom20.com/profile/RobertZenhausern
Dragging the handle down 100 lines can be a tedious process and horrible if you had 1000 or more lines. Let me suggest an alternative. When you put the cursor in the lower left corner of the cell with the formula, the cursor will turn into a cross. Double click on that and the formula will copy down for as many rows as there are data. The data must be in an adjacent cell.
Dragging the handle down 100 lines can be a tedious process and horrible if you had 1000 or more lines. Let me suggest an alternative. When you put the cursor in the lower left corner of the cell with the formula, the cursor will turn into a cross. Double click on that and the formula will copy down for as many rows as there are data. The data must be in an adjacent cell. Thanks! We were able to get o…tag:www.classroom20.com,2009-10-30:649749:Comment:3989682009-10-30T17:24:50.016ZDarcie Priesterhttps://www.classroom20.com/profile/DarciePriester
Thanks! We were able to get our answer and we've got a spreadsheet now.
Thanks! We were able to get our answer and we've got a spreadsheet now. You can absolutely do this. H…tag:www.classroom20.com,2009-10-30:649749:Comment:3987972009-10-30T01:51:21.284ZJenn Brookshttps://www.classroom20.com/profile/JennBrooks
You can absolutely do this. Here are two different ways:<br />
<br />
1. Enter the formula in the top cell of the column and press enter. Click on the top cell again and a small square in the lower right hand corner of the cell will appear. Click on it and pull down through all the cells you would like to add the formula to.<br />
<br />
2. If you copy the cell with the formula and highlight all of the cells you want to add the formula then click paste, it should paste it to all the cells at once.
You can absolutely do this. Here are two different ways:<br />
<br />
1. Enter the formula in the top cell of the column and press enter. Click on the top cell again and a small square in the lower right hand corner of the cell will appear. Click on it and pull down through all the cells you would like to add the formula to.<br />
<br />
2. If you copy the cell with the formula and highlight all of the cells you want to add the formula then click paste, it should paste it to all the cells at once.