Query on Excel help for adding $ sign to formula

Hi,

I have range of cells with forumula which have references to other cells.

For example:: In cell A1 I have forumula "=B1*C1"

                          In cell A2 I have forumla" =B2*C2"

 

I want to select these two cells A1 and A2 and make forumulas in them permanent.

For example I want in cell A1 I want the forumula to be "=$B$1*$C$1"

How to do this in one stroke for all selected cells. Is there any shortcuts for this?

 

Thanks

 

 

 

Replies (5)

 ya, u can create in one stroke , just go to a1 cell, & then just press (F2) for goin to editing mode to cell A1.& then just press (F4) for adding dollar sign 

 

i think the idea suggested by Ayush will not solve the purpose coz it will take effect only into the particular cell edited & not the whole range selected.

You may try the following :

Select the range containing the formulae. Cntrl+H. Find B Replace with $B$. Replace All.

Repeate same for C.

plz tell me to the Excell Formalas.

 HEY, yar anil, u just want to edit A cell naaa.,,, then just do as i suggested, & copy it & paste in same range u want.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details