excel formula help - ExcelBanter

bala_vb

Senior Member

Location: Hyderabad

Posts: 237

Quote:

Originally Posted by bill_ball

earlier i worked with array formula very well. now i forgot and couldnot recall the method to edit the formula.

anybody help is highly appreciated.

hi bill,

try this....

after editing the formula, select the entire formula in the formula bar

and press ALT + CLTR + ENTER KEY.

all the best

__________________
Thanks
Bala

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
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible	blue[_2_]	Excel Discussion (Misc queries)	2	July 11th 07 06:08 PM
Build excel formula using field values as text in the formula	val kilbane	Excel Worksheet Functions	2	April 18th 07 01:52 PM
Excel Formula Doesn't Execute (Shows formula-not the calcuation)	Keys1970	Excel Discussion (Misc queries)	4	November 15th 06 02:12 PM
Excel 2002 formula displayed not value formula option not checked	Dean	Excel Worksheet Functions	1	February 28th 06 02:31 PM
How do I view formula results intead of formula in excel?	davidinatlanta	Excel Worksheet Functions	4	February 7th 06 03:02 PM

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

About Us