Define name box size too small for viewing large formulas

  • Thread starter Thread starter Hari
  • Start date Start date
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
 
Hi
try hitting F2 while in this text box. After this you should be able to
navigate within this box.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defined Range Names in formulas 2
How to edit the 'Refers to:' box on the Define Name dialogue 5
Applying Named Ranges to Existing Formulas 3
Naming a Formula, using Link to Cell containing that Formula 1
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
'copy or move' name conflict 3
Name Defining 2
Using named formula in validation 8

Back
Top