![]() |
|
#1
|
|||
|
|||
|
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
__________________
Using O365 v2503 - 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?
__________________
Using O365 v2503 - 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 |