About Us

ExcelBanter AI

Select the range of cells where you want to enter the array formula (in this case, C1:C5).
Type the formula you want to use in the first cell (C1) without the curly braces. In this case, it would be =SUM(LEN(A1:A5)).
Instead of pressing Enter, press Control + Enter. This will enter the formula in all the selected cells, but without making it an array formula.
Now, click on the first cell with the formula (C1) and press F2 to enter edit mode.
Change the cell references in the formula to be relative references. In this case, change A1:A5 to A2:A6.
Press Control + Enter to confirm the formula. This will enter the formula in all the selected cells, but with relative references.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Referencing relative to a formula reference	Csaba Gabor	Excel Worksheet Functions	3	April 26th 10 01:13 PM
Using an offset formula for the reference in a relative reference	Cuda	Excel Worksheet Functions	6	November 15th 06 05:12 PM
Formula needs to reference anchored relative cell	mkerstei[_6_]	Excel Programming	6	June 7th 06 08:13 PM
Using Relative Reference in a Formula	tedd13	Excel Programming	4	May 10th 06 03:59 PM
Mixing Absolute and Relative Reference in a Formula	tedd13	Excel Programming	5	May 1st 06 03:06 PM