Sunny has attended:
Excel Introduction course
How do you lock in a cell using F4? So you don't need to copy it
How do you lock in a cell using F4? So you don't need to copy it down and the formula doesn't move down with it.
I just can't remember how to do it! PLease help :)
RE: How do you lock in a cell using F4? So you don't need to cop
Hi Sunny
F4 only creates absolute references when inside the formula.
You would start with the formula and when you have selected the cell that needs to be locked then press F4
So when used in your formula, the formula would look something like
=A2*$B$1
You can read the article below for more information
https://www.stl-training.co.uk/article-471-employing-cell-references-in-excel.html
Hope this helps
Kind regards
Wendy Canelas
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
