Thread: [Solved] excel absolute reference
View Single Post
 
Old 06-15-2015, 11:45 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,780
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default
Quote:
Originally Posted by macropod View Post
According to Excel's help file:
• F4 Repeats the last command or action, if possible.
• CTRL+F4 closes the selected workbook window.
• ALT+F4 closes Excel.
As you can see, F4 does not convert a cell reference to absolute.
I don't know what XL help file says, but when in a formula you put the insertion point behind a cell ref in a formula or select the ref, F4 will toggle absolute and relative references
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote