Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

Re: Calculation Software

[Subject Prev][Subject Next][Thread Prev][Thread Next]
>Personally, I'm too lazy to name cells and ranges as I go.
I was too, long ago.

Enter the variable names in cells to the left of the formulas they 
produce. Select the range containing both the formulas and the variable 
designations and select 'Create Names' in the Formula menu. Then pick 
'Define Names' to review the names which were created just to be sure you 
have everything. Edit the names if you feel like it. For example if one 
of the names comes out 'Operating Pressure-Po' you could change it to 
'Po.' When you're satisfied that the names look like you want, select the 
all the cells with formulas and pick 'Create Names' from the Formula 
menu. Excel changes all your cell references automagically to the cell 

Once you see how easy it is to troubleshoot a worksheet with names 
instead of cell references, you never go back.

Christopher Wright P.E.    |"They couldn't hit an elephant at
chrisw(--nospam--at)        | this distance"   (last words of Gen.
___________________________| John Sedgwick, Spotsylvania 1864)

******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at:
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*   Questions to seaint-ad(--nospam--at) Remember, any email you 
*   send to the list is public domain and may be re-posted 
*   without your permission. Make sure you visit our web 
*   site at: 
******* ****** ****** ****** ******* ****** ****** ********