How do you lock in a cell using F4? So you don't need to copy it

Resolved · High Priority · Version 2010

Thu 17 May 2018, 06:39 Delegate Sunny said...

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 :)

Thu 17 May 2018, 08:40 Trainer Wendy said...

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

Wed 23 May 2018, 10:30 Trainer Wendy said...

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.

Wed 30 May 2018: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips