Posted to microsoft.public.excel.programming

Mpho[_2_]

external usenet poster

Posts: 5

Fixed Columns

Hi! Excel programmers,I have a problem with cells.

Problem
I have a formula in cell A1 which is B1*C1,problem is if i
select lets say column B and insert a column, the formula
in cell A1 changes to C1*D1 and which is not what i want.I
would like to make this formula to stay constant even i
add columns.

Thanks a lot, your help it is highly appreciated.

Mpho

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
Rows & Columns Fixed Width / Height	Elgee	Excel Discussion (Misc queries)	2	August 22nd 08 10:19 PM
Fixed 26 million rows, now 16,000 columns- help help!	The BusyHighLighter[_2_]	Excel Discussion (Misc queries)	2	August 1st 07 04:14 AM
formula to stay fixed on two columns as you add more columns	usingexcel	Excel Discussion (Misc queries)	1	August 3rd 06 01:25 AM
fixed columns	mit76	Excel Worksheet Functions	1	March 21st 06 09:15 PM
Printing fixed columns and rows	rcorona106	Excel Programming	4	December 19th 03 12:03 AM

All times are GMT +1. The time now is 08:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us