Need a book? Engineering books recommendations...

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

RE: Calculation Software

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Keep pressing F4 until you get the cell reference state you desire.
T. William (Bill) Allen, S.E. (CA #2607)	
Consulting Structural Engineers	
V (949) 248-8588	 .	 F (949) 209-2509	

-----Original Message-----
From: Paul Ransom [mailto:ad026(--nospam--at)] 
Sent: Wednesday, July 21, 2004 8:27 AM
To: seaint(--nospam--at)
Subject: Re: Calculation Software

> From: "Bill Allen" <T.W.Allen(--nospam--at)>

> name, so the Name/Create method won't work. Even w/o the "=", my version
> doesn't automatically add the underscore. That must be a "value added
> feature" on the Mac version :o).

Like the key combination (apple-T) to cycle through cell reference
states: A1, $A$1, A$1, $A1.
I haven't found an equivalent on non-Mac versions of Excel (though I may
have missed it). There are other variations as well.


******* ****** ******* ******** ******* ******* ******* ***
*   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: 
******* ****** ****** ****** ******* ****** ****** ********