Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

short cut to fixed cell definition input type $A$1

Status
Not open for further replies.

fetraining

Aerospace
Jul 29, 2008
17
I have been shown in the past how to use a built in hot key or function key to make any cell reference in an equation a fixed reference, on the fly. However I have forgotten how and can't find any reference in the help documentation.

So instead of clicking on cell A1 when building an equation, getting A1 in the input line, then manually editing to $A$1, there is a hot key that will cycle through $A$1, A$1, $A1.

many thanks,



Tony Abbey
 
Replies continue below

Recommended for you

Status
Not open for further replies.

Part and Inventory Search

Sponsor