Posted to microsoft.public.excel.programming

darsg

external usenet poster

Posts: 13

Making Excell formula constant

i have got a sum of figures of column b i row a29as a formula in a29 my
formula is "=b27"

when i insert a column between a and b my formula chagnes to
"=c27"
I want my formula to be constant.

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
making graphs in excell	Alexis	Excel Discussion (Misc queries)	1	August 2nd 07 07:53 PM
Making a CSV from several collumns in excell	patrick007	Excel Discussion (Misc queries)	3	August 3rd 06 03:39 PM
making variables constant	Milo	Excel Worksheet Functions	1	November 2nd 04 01:45 AM
making a column of formuls constant	Jake	Excel Worksheet Functions	2	November 2nd 04 01:45 AM
making calculated fields constant.	Jake Mackey	Excel Worksheet Functions	1	November 2nd 04 01:44 AM

All times are GMT +1. The time now is 03:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us