Hank, the confusion came from us not understanding what the OP was talking about, he said he needed to apply a formula to 2 colums. We were all on the same page except the OP so there was a communication error. I am glad that he was able to accomplish what he wanted to do but i don't think any of us knew what he was trying to do until his last post. Also I am not saying that he needs to install a plugin to do that but ASAP utilities is useful for a myriad of shortcuts in excel and not just taking 2 steps out of the paste special method. Anyone that uses Excel much should look try it. Everyone that i have gotten to use it can't live without it now.

Excel for Mac Text. Cell I2 contains a formula to calculate the monthly payment for that row. Copy the selected column (in Excel 2008, follow the menu. Dragging the AutoFill handle is the most common way to apply the same formula to an entire column or row in Excel. Firstly type the formula of =(A1*3+8)/5 in Cell C1, and then drag the AutoFill Handle down to the bottom in Column C. Then the formula of =(A1*3+8)/5 is applied in the whole Column C.

There are several ways to approach this. Pick the one that works with how you plan to use column A of Sheet1. =SUM(Sheet1!A:A) This will add up all the numbers in column A. As long as the header in A1 is not a number, it will not affect the total.

There are actually a lot of programs that support DVD playback on Mac system. Free dvd player software mac os x.

This is a good choice if you don't plan to put anything else in Column A =SUM(Sheet1!A2:A100) This will add up all the numbers from A2 to A100. Empty cells will not affect the total. Change A100 to the address of the last cell that might be part of the data. It would be a good idea to use formatting on Sheet1 (borders or fill colours) to indicate the range that you have set aside for this use. =SUM(Sheet1!A2:A11) This is the formula you are already using. You can mark Sheet1 (using borders of fill colours) to remind you which cells can be used.

When you want to insert another cell of data, do just that - use Insert to add another cell to the range A2:A11) The range will now be A2:A12, and the formula in Sheet2 will be automatically changed to SUM(Sheet1!A2:A12).