Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba-excel-training - Absoluting values
|
|
|
The UK's most regular 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. |
vba-excel-training - Absoluting values
Resolved · Low Priority · Version Standard
Reply Mon 12 Nov 2007, 12:10Delegate Karen said...
Karen has attended:
Excel Advanced course
Absoluting values
Is there any way of absoluting a block of cells with the same formula in??
For upcoming training course dates see: Pricing & availability
RE: Absoluting values
Hi Karen, Thank you for your post, its good to hear from you, there are a couple of ways of answering your post;
1. To Absolute a single cell - select the cell reference in the formula and press the F4 key (Function 4) this will append the $ signs to the cell reference making it absolute. now copying this formula using the Fill handle, will "pin" that cell reference in the formula to the absolute cell.
2. To apply absolute to a range of cells (a block) I think it would be easier to Name the range, to do this select the cells and then click in the Name Box (on the left hand end of the formula bar) type in a meaningful name and press the enter key. This has named the cells and the name can be used in a formula ie =sum(Data2007) this will total all the cells in the named range Data2007, naming other ranges will allow you to create formulas of named ranges which will be absolute across the entire workbook. Hope that helps, Pete
|