# How to Lock Cells in Google Sheets Formulas (The Easy Way!)

In this article we will show you how to lock cells in Google Sheets formulas. This is important to keep your formula working once you copy the cell containing it down a column or along a row. Just follow the simple steps below:

## How to Lock a Cell in a Google Sheets Formula

### Step 1: Identify which parts of your formula should be locked

For our example, we want to calculate the weighted score given the following data:

The formula is

Weighted score = ( 0.40 * Column A ) + ( 0.25 * Column B ) + ( 0.35 * Column C )

We can “hard-code” the weights of each column but we want to have flexibility of being able to change their weights when needed, thus storing the weights at different cells. We store 0.40 at B2, 0.25 at C2, and 0.35 at D2.

### Step 2: Add the formula to a selected cell

We will start with the first entry which is in Row 3. The specific formula is

=B2*B3+C2*C3+D2*D3

We place this formula in E3, along the column labeled Weighted Score.

### Step 3: Lock the selected parts by adding the dollar sign (\$)

Start clicking at the formula to add dollar signs on the cells that should be locked. For our example it should look like as follows:

=\$B\$2*B3+\$C\$2*C3+\$D\$2*D3

One way to add dollar signs (\$) is to click at the equation bar and then insert the dollar signs at the right cells:

### Step 4: Press Enter

The result is:

When you copy the formula by dragging down cell, you will get the formulas correctly copied:

# Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
Creates a one- or multiple-day calendar event with optional attendees
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL