#1
|
|||
|
|||
excel absolute reference
My laptop will not allow me to use the keyboard shortcut of f4 to establish a cell as an absolute reference. Is there a way to do it without having to type in the dollar signs manually? |
#2
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Are you in editing mode?
It only works if you are in editing mode. It is a windows shortcut. https://exceljet.net/keyboard-shortc...ive-references Last edited by jolivanes; 06-15-2015 at 09:48 PM. Reason: add hyperlink |
#4
|
||||
|
||||
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 |
#5
|
||||
|
||||
OK, the help file doesn't deal with pressing F4 while the formula bar is active. When I press F4 with the formula bar active, the referencing for a cell reference adjacent to the insertion point alternates between A1, $A$1, A$1 and $A1 referencing.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
||||
|
||||
I do wonder why it does not work for the OP, though?
__________________
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 |
#7
|
||||
|
||||
Possibly because the formula bar isn't active. Simply clicking on a cell and pressing F4 isn't enough.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to write reference into powerpoint graph from excel tab | gulf2014 | PowerPoint | 0 | 10-18-2014 06:11 AM |
Header Field code to reference excel | dianabanana | Word | 1 | 04-08-2014 03:31 PM |
Keeping an absolute reference in a cell | bremen22 | Excel | 7 | 01-16-2014 11:06 AM |
Circular Reference Warning in Excel Sheet. | Rahmat_uk20 | Excel | 3 | 06-08-2012 02:31 AM |
Excel VBA: How to add a reference to Microsoft Word Object Library? | tinfanide | Excel Programming | 7 | 12-12-2011 05:21 AM |