KC Mao

Posts: n/a

copy a cell value not its function

Excel question:

ce11 A1 value=500
Cell B1 value=600
Cell C1 value=2000
Cell D1 value=50
Cell E1 value=C1-D1-B1-A1
use contrl+D to copy cell E1 value all the column down to cell E100
What I wnat is to use contrl+D to copy E1 value not its fuction.

Please if someone could help.

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
Maintaining cell reference after sorting	GRITS	Excel Discussion (Misc queries)	2	April 30th 23 07:42 PM
Aligning Two Lists in Excel	Rich	Excel Discussion (Misc queries)	2	December 4th 04 05:44 PM
Copy an IF function when Inserting new row	Philobr	Excel Discussion (Misc queries)	1	December 3rd 04 10:45 AM
copy paste cell character limit	Fred	Excel Discussion (Misc queries)	1	December 2nd 04 08:58 PM
Is there a way to transfer a style by cell referrence in a formula	Binki55_CanYouHearMeNow	Excel Discussion (Misc queries)	1	November 30th 04 06:08 PM

All times are GMT +1. The time now is 01:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us