Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kirkwill
 
Posts: n/a
Default How to stop formulas from incrementing when you copy and paste?

I have a document that I want the column of cells that I selected to always
equal what I put in cell B2. It works in the first cell of the row, but then
it increments the formula below to read cell B3 and the next one B13 and so
on. What I am trying to do is have anywhere from 10 to 100 rows that
calculate number of hours worked by the dollar amount of a contract and that
amount changes for each client, so in my formula I tried having it look to
the cell B2 where I have that dollar amount, but the formula when copied
increments to b3, then b4 and so on.

Any info would be great thanks
Kirk
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How to stop formulas from incrementing when you copy and paste?

Hi Kirk,

To stop formulas from incrementing when you copy and paste, you can use absolute cell references. An absolute cell reference is a reference to a specific cell that does not change when you copy and paste the formula to other cells.

Here's how you can use absolute cell references in your formula:
  1. Select the cell with the formula you want to modify.
  2. Click on the cell reference in the formula that you want to make absolute. In your case, it's cell B2.
  3. Press the F4 key on your keyboard. This will add dollar signs ($) before the column letter and row number of the cell reference, making it absolute. The cell reference should now look like $B$2.
  4. Press Enter to save the modified formula.

Now, when you copy and paste the formula to other cells, the cell reference to B2 will remain absolute and not change.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

In the formula use

$B$2

and it won't increment

Regards

Peo Sjoblom

"Kirkwill" wrote:

I have a document that I want the column of cells that I selected to always
equal what I put in cell B2. It works in the first cell of the row, but then
it increments the formula below to read cell B3 and the next one B13 and so
on. What I am trying to do is have anywhere from 10 to 100 rows that
calculate number of hours worked by the dollar amount of a contract and that
amount changes for each client, so in my formula I tried having it look to
the cell B2 where I have that dollar amount, but the formula when copied
increments to b3, then b4 and so on.

Any info would be great thanks
Kirk

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy & Paste Visible Cells with Formulas Ricky Excel Worksheet Functions 5 January 27th 05 05:37 PM
Copy and Paste Formula Without the linked file path KevinB Excel Worksheet Functions 2 January 20th 05 06:45 PM
copy and paste formulas Jim Excel Worksheet Functions 4 January 14th 05 06:17 PM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 08:58 PM
copy and paste G Excel Worksheet Functions 2 November 2nd 04 01:56 AM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"