how do i put a formula into a column in excel for mac?

How Do I Put A Formula Into A Column In Excel ? Full Versions Also

If you have a list of names with one cell containing a first name and one cell containing a last name, you might want to merge them into one cell, where the first and last name appear together.

The last names are in column A and the first names are in column B.

Adding at the end lets Excel know you want to perform a combination.

For example, if we wanted to combine Bob Regans name into cell C2, we would type into C2: B2 A2.

Rather, we can click the bottom right corner of cell C1, which contains Joe Smith, and drag the corner down to have Excel replicate the formula.

After performing this task, our spreadsheet looks like this.

Because most copies you make of formulas require adjustments of their cell references, you rarely have to give this arrangement a second thought.

This happens most often when you want to compute what percentage each part is to the total.

The formula in cell B14 for calculating the percentage of the January-sales-to-first-quarter-total is very straightforward.

Look, however, at what would happen if you dragged the fill handle one cell to the right to copy this formula to cell C14.

However, the adjustment of the second cell reference from E12 to F12 is a disaster.

Not only do you not calculate what percentage the February sales in cell C12 are of the first quarter sales in E12, but you also end up with one of those horrible DIV0 error things in cell C14.

To do this, press the function key F4, after you apply Edit mode (F2).

You make the cell reference absolute by placing dollar signs in front of the column letter and row number.

For example, cell B14 contains the correct formula to copy to the cell range C14:D14.

If you press the F4 function key a second time, you end up with a so-called mixed reference, where only the row part is absolute and the column part is relative (as in E12).

If you press F4 yet again, Excel changes the cell reference back to completely relative (as in E12).

After youre back where you started, you can continue to use F4 to cycle through this same set of cell reference changes.

Pick your course (you may be interested in more from Excel 2013 ), fill out a quick registration, and then give eLearning a spin with the Try It button.

How Do I Put A Formula Into A Column In Excel ? Full Versions Also

Youll be right on course for more trusted know how: The full versions also available at Excel 2013.

He has written all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies.

Greg is an experienced educator with a wide variety of interests.

How Do I Put A Formula Into A Column In Excel For Mac?