Excel tips : exact formula copies

Excel Tips : Exact Formula Copies

 

Many formulas in a worksheet don't occur in solitude—they often appear numerous times in a worksheet. For instance, you may copy a formula into a range of cells in a column, each formula operating on data on its own row.

When you copy formulas, Excel automatically adjusts any relative cell references in the formula so that they remain relative in the target cell. For instance, if a formula in cell C4 is =A4+B4, then copying the formula down to cell C5 results in the formula =A5+B5.

There may be times when you want to create an exact copy of a formula, without Excel adjusting the relative cell references during the copy process. Assuming you want to make an exact copy of the formula in cell C4 and copy it to C5, follow these steps:

Select cell C4.

Press F2. Excel enters Edit mode, with the insertion point at the end of the formula.

Press Shift+Ctrl+Home. Excel selects everything in the cell, back to the beginning of the formula.

Press Ctrl+C to copy the selected text (the formula's text) to the Clipboard.

Press Enter to move to cell C5.

Press Ctrl+V to paste the Clipboard contents into the cell.

During this paste process, the relative cell references are not updated—the formula in cell C5 is now an exact duplicate of the one in cell C4.

 

Replies (4)

Thanks for sharing............................

@ ! @

S.S.D.N

And if you want to paste different formula frequently, press Ctrl-C twice (as mentioned by Praveen Kumar) to popup Excel inbuilt clipboard on righthand side. From this clipboad you can see all the copied formula before pasting. Thus it will help to decide which formula to paste at certain cell reference. This clipboard is alos very useful for other normal copy & paste operations.
 

------------------------------------------------------------
Free Exshail Classic menu for Excel-2007 +

 

 

 

 

Originally posted by : PRAVEEN KUMAR


Excel Tips : Exact Formula Copies

 


Many formulas in a worksheet don't occur in solitude—they often appear numerous times in a worksheet. For instance, you may copy a formula into a range of cells in a column, each formula operating on data on its own row.

When you copy formulas, Excel automatically adjusts any relative cell references in the formula so that they remain relative in the target cell. For instance, if a formula in cell C4 is =A4+B4, then copying the formula down to cell C5 results in the formula =A5+B5.

There may be times when you want to create an exact copy of a formula, without Excel adjusting the relative cell references during the copy process. Assuming you want to make an exact copy of the formula in cell C4 and copy it to C5, follow these steps:





Select cell C4.

Press F2. Excel enters Edit mode, with the insertion point at the end of the formula.

Press Shift+Ctrl+Home. Excel selects everything in the cell, back to the beginning of the formula.

Press Ctrl+C to copy the selected text (the formula's text) to the Clipboard.

Press Enter to move to cell C5.

Press Ctrl+V to paste the Clipboard contents into the cell.

During this paste process, the relative cell references are not updated—the formula in cell C5 is now an exact duplicate of the one in cell C4.


 

thanks.........

One can also insert $ sign befor the name box to keep it constant ; if u wanna keep C4 same in all rows or coloumns then put $C4$ n thn copy paste

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details