MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula is too long

Posted by Michael on October 12, 2000 1:29 PM

My formulas make multiple references to cells on
another worksheet, and each time the full name of the
other sheet is included in the formula -- making the
formulas much larger and appear more complex than they
need to be.

For example:

Is there anyway to eliminate some of the "Sheet1"

Posted by Ivan Moala on October 13, 2000 1:59 AM

One way is ;
Goto Insert / name /define

Type in "MyName" or what ever
Then define your Ref here eg =Sheet1!A1-Sheet1!A2+Sheet1!C4-Sheet1!E1+Sheet1!B7


Then in any cell just type in



Posted by AB on October 13, 2000 8:47 AM

You could make it a practice to seperate your links from your formulas.

Put your links on a "Link" sheet and then just let your formulas refer to the Link!A1 cell or whatever.