Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel word powerpoint courses london - Excel

excel word powerpoint courses london - Excel

ResolvedVersion Standard

Wed 28 Nov 2007, 14:14 Delegate Sally said...

Sally has attended:
Excel Introduction course

Excel

What is absolute cell referencing?

Thu 29 Nov 2007, 13:05 Delegate Paul said...

RE: Excel

It's where you put a $ in before a reference. This forces Excel to look at the very same cell no matter how far you drag out your formula

so if you were to put in C1 the following fomula: =A1+B1 and drag the formula down from C1 thru C100 the formula in those dragged out cells would be, for instance =A25+B25

but if you put =$A$1+B1 and drag it out, the formula in cell C25 would be =$A$1+B25

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

excel word powerpoint courses london - Excel

Excel

RE: Excel

Excel articles

Excel tip:

Add Text to Displayed Numbers in Excel 2010