Define name box size too small for viewing large formulas

H

Hari

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
 
F

Frank Kabel

Hi
try hitting F2 while in this text box. After this you should be able to
navigate within this box.
 
Top