What is the shortcut for making a cell reference in a formula absolute or relative?
M Mel Jul 5, 2003 #1 What is the shortcut for making a cell reference in a formula absolute or relative?
B Beth Melton Jul 6, 2003 #2 Hi Mel, If you are referring to Excel it's F4. Note when not creating a formula F4 will is assigned to the Repeat command. Please post all follow-up questions to the newsgroup. Requests for assistance by email can not be acknowledged. ~~~~~~~~~~~~~ Beth Melton Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/
Hi Mel, If you are referring to Excel it's F4. Note when not creating a formula F4 will is assigned to the Repeat command. Please post all follow-up questions to the newsgroup. Requests for assistance by email can not be acknowledged. ~~~~~~~~~~~~~ Beth Melton Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/