98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Introduction
Excel Introduction
Resolved · Low Priority · Version 2003
Jo has attended:
Excel Introduction course
Excel Introduction
Cab you explain in more detail absolute cells
RE: Excel Introduction
Hi Jo, Thank you for your post, Welcome to the forum, I hope you enjoyed your course. In answer to your question; Absolute and Relative referencing are a very important part of creating formulas; When we create a formula we can stipulate to Excel whether or not to fix a cell reference so that it is referenced at all times if the formula is copied to another cell. Copying a formula to another cell is accomplished by using the Fill handle, (the little square at the bottom right hand corner of a selected cell or range of cells). When we use Relative referencing and copy the formula using the Fill handle, the formula is copied using the original pattern, ie if the pattern is =A1*B3, the formula will become =B1*C3. If we need to reference cell A1 continuously we will require to "fix" this cell in our formula, using the F4 key (Function 4) at the top of the keyboard, we can apply $ signs to our formula, (Note: pressing the F4 key will cycle through a number of options to fix all, column or row). Select the cell into which you wish to create the first entry, type your formula, =A1*B3, in the Formula bar, select the A1 section of the formula, press the F4 key and $ signs will be placed in front of the A and the 1 (=$A$1*B3) or you could type the $ signs in place, press enter to activate the formula, using the Fill handle copy the formula to adjacent cells to the right. The formula will copy as follows, =$A$1*C3, and the next cell =$A$1*D3,
This is known as Absolute Referencing. I hope that helps, if so please click the Resolved link, best regards Pete.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Naming and Using ConstantsConstants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant. |