Define name box size too small for viewing large formulas

From: Hari (excel_hari_at_hotmail.com)
Date: 07/22/04 

Date: Fri, 23 Jul 2004 01:00:35 +0530

Hi,

When we create a new name using insert and define name then if the formula
is long it becomes difficult to view the whole formula. Also one is not able
to use navigation buttons left,right here as if we do that then the formula
gets modified. is there any way to see the whole formula. Like for creating
ever expanding validation list using Debra's technique one uses offset etc
but one is not able to view the whole big formula.

Please guide me.

Regards,
Hari
India