Absolute references in Calculated Table columns

Posted to microsoft.public.excel.misc

Humphrey

external usenet poster

Posts: 22

Absolute references in Calculated Table columns

I need to create an absolute reference in a calculated column so that when I
copy the formula across to subsequent columns the formula continues to refer
to the equivalent of $D4. How is this done using table columns? When I copy
now to the next column it applies a relative reference.

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with converting a block of cells with Absolute and mixed references to relative references	Vulcan	Excel Worksheet Functions	3	December 13th 07 11:43 PM
Absolute References	Dan Beard	Excel Discussion (Misc queries)	3	October 16th 07 03:20 AM
Calculated Field and Calculated Item in Pivot Table	Fred Smith	Excel Discussion (Misc queries)	0	March 4th 07 08:15 PM
Absolute References	[email protected]	Excel Worksheet Functions	1	November 29th 06 12:41 AM
pivot table formulas for calculated field or calculated item	Vicky	Excel Discussion (Misc queries)	3	June 6th 06 05:06 AM

All times are GMT +1. The time now is 08:39 PM.

Menu

About Us