How to drag formulaes in Microsoft excel ?
475445
Use as the one above told you\n\n\nOR\n\njust copy and paste it\n\nXLMan
720620
Click on the arrow and drag it
688072
have your data in columns in Excel\nclick the graph icon in the upper tool bar\nselect the chart type\nclick next\ndrop and drag (with control key pressed)\nAfter that, email me
778758
.\nI understand.  Am in the same boat...just getting back to work after many years.\n\n1.  Open Excel\n2.  Enter data in cells\n3.  You must highlight all cells you want totaled.\n4.  To highlight click the first cell you want added > then hold down keyboard SHIFT key >\nthen click below last cell, in an empty cell where total will appear.\nYou may total several columns at the same time.\nTo total a row, drag across the row.\nIn above tool bar click the "sum" button\n(it looks Greek like a backwards E\n\n5.  To see the formula Click in cell where the answer appears and look above  \n\n6.  You will see the "sum formula" in the long white  text box for "Insert Function"\nIn that text box you can type in and can change your formula for the area you want it to cover by changing the formula to\none column \n[example]         =SUM(A1:G1)\none row\n[example]         =SUM(A1:A8)\nseveral columns\n[example]          =SUM(A1:G8)  \nThe first number is the first column/cell\nthen a colon\nthen the last number is the last column/cell\n\nNow for other help remember the Office Assistant is totally cool.  It even helped me at exam time, hee hee.  Click on the question mark on the above tool bar, and when the "assistant" appears type in your question.\n\nGlad to help\nstw\n.
1130468
This add-in may be what you need.\n\nhttp://www.cpearson.com/excel/RowLiner.htm
760528
1) Left click on first cell in row.\n2) Hold down the shift key and Left click the cell AFTER the last grade\n3) Sum button
585556
Copy the formula, then select the cells in the row you want, and paste it...Excel should apply the formula to the corresponding columns.
829436
Just add an extra column which extracts only the month and the day from the date column. Let's suppose that the column containing dates is column A, staring with row 2. In the extra column, on the second row, the formula will be:\n=TEXT(A2, "mmdd"). Copy the formula downwards, for all the rows.All you have to do then is to sort by that extra column
801228
I'm using Excel 2003. This solution should work for any recent version of Excel. \n\n1. Select the entire worksheet. You do this by either 1) clicking on the "select all" button, which is located between the labels for row 1 and column A (the very top left corner), or 2) press "Ctrl+A".\n\n2. On the top bar menu, choose Data/Sort. Choose the column on which you want to sort. (It almost doesn't matter for your purpose, but if you have a preferred order you might as well choose it now.) \n\nBe sure that the order is Ascending for now, even if you want it to be Descending in your final sort.\n\nIf your worksheet has a header row, you'll want to select the "Header row" radio button. If you choose this option, your header row (row labels) will stay at the top of your sort. If you choose "No header row," the header row labels will sort with the rest of your data.\n\n3. Click "OK." If the sort order is Ascending, your blank rows should be at the bottom of your list. If you had chosen to sort in Descending order, the blank rows would be at the top and you'd have to do a follow-up step of selecting the blank rows and deleting them. \n\nHope that helps.
831601
Create a table. Fill in each number you want to add in the same column, but different rows. Leave one column empty at the end. Go to the Toolbar and click on Table. Then click on formulas. In the Formula box you add your formula:\n=SUM(above).\n\nCreate a table. Fill in each number you want to add in the same row, but different column Leave one column empty at the the far right. Go to the Toolbar and click on Table. Then click on formulas. In the Formula box you add your formula:\n=SUM(left).\n\nFor autotext features:\nAuto Correct Tab:  Fill in a word you want to replace in the box and then type the word you want to replace it with. I do this for words I tend to misspell. (I.e., wierd with weird)\nOn the auto text text you can fill in a phrase that you would like completed so you don't have to type it in. You could use your name. John A Doe. When you type John the rest of the name will appear and all you have to do is hit enter and the name is completed.
110093
Copy then paste the value only.  From Excel Help:\n\n"Replace a formula with its result\nYou can "freeze" a formula so that it no longer recalculates by replacing a formula with its calculated value. If you want to freeze only part of a formula, you can replace only the part you don't want to recalculate.\n\nReplace a formula with its calculated value\n\nCaution   When you replace a formula with its value, Microsoft Excel permanently removes the formula. If you accidentally replace a formula with a value and want to restore the formula, click Undo  immediately after you enter or paste the value.\n\nSelect the cell that contains the formula. \nIf the formula is an array formula, select the range that contains the array formula. \n\nHow? \n\nClick a cell in the array formula. \nOn the Edit menu, click Go To. \nClick Special. \nClick Current array. \nClick Copy . \nClick Paste  on the Standard toolbar. \nClick the arrow next to Paste Options , and then click Values Only. \nReplace part of a formula with its calculated value\n\nCaution   When you replace part of a formula with its value, it cannot be restored.\n\nClick the cell that contains the formula. \nIn the formula bar , select the portion of the formula you want to replace with its calculated value. When you select the part of the formula you want to replace, make sure to include the entire operand. For example, if you select a function, you must select the entire function name, the opening parenthesis, the arguments, and the closing parenthesis. \nTo calculate the selected portion, press F9. \nTo replace the selected portion of the formula with its calculated value, press ENTER. \nIf the formula is an array formula, press CTRL+SHIFT+ENTER. "
738595
Try this:\nRange("a1").Select\nc_value = Trim(ActiveCell.Value)\nmsgbox ("You have " & c_value & " cookies")
353166
just drag in the other side, in the left, in the right on the top or back to basic ^_^
1005206
the same way you do it with excel...
358817
- Open MS-Excel;\n- Start adding all the equations you want;\n- Save the file once done...\n\nEquation Example:\nA simple adding equation:\n- type the number 1 in cell A1\n- type the number 2 in cell A2\n- type =A1+A2\n\nand you are done\n\nTo type, click on the cell with the mouse, then type, or double-click on the cell and type\n\nTo confirm text and exit editing it, hit the Enter button\n\n_________________________\n\nTips:\n=====\n- you can use any of the following: + - * /\n- to start an equation, it must start with the = sign\n- ^ is the power sign\n- pi is used in geometry [EX: type pi() to get its value]\n\n\nHope this helps a little...
1012031
click on a cell, type the = sign then click on another cell, type a mathematical function such as + or -, then click on another cell.  hit enter and there you have a calcutation.
990843
You can call it from VB6 using\nWorksheetfunction object\nthis object has all the functions in Excel\n\nenjoy\n\nXLMan