Ask Experts Questions for FREE Help !
Ask
    anetword@yahoo.com's Avatar
    [email protected] Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Mar 5, 2010, 03:59 AM
    How to use absolute addressing in excel
    How to change absolute addressing to relative addressing
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Mar 5, 2010, 11:14 AM

    You use the $ symbols to make portions of a reference absolute.

    A1 - column relative, row relative
    $A1 - column absolute, row relative
    A$1 - column relative, row absolute
    $A$1 - column absolute, row absolute
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Hippa laws regarding addressing patients [ 8 Answers ]

I work in a doctor's office. Under hippa Law, do we address patients by their first or last names?

IP Addressing - post moved [ 1 Answers ]

What is the difference between Classless & Classfull Ip Addressing ?

Addressing an invitation [ 6 Answers ]

When addressing an invitaion and the wife is a physician and the huband is not, how does one appropriately address it?

Need able addressing legal/criminal issues [ 6 Answers ]

my husband (although we are not "legally married") and i have some issues we are trying to resolve. i am a graduate student and he works from home making jewlery. he has had some past legal criminal trouble we are trying to sort out on a very very very limited budget. i am about to get a job...

Excel: change relative address to absolute address [ 1 Answers ]

Hi, In Excel spreadsheet, how to change relative address to absolute address for many cells at same time? I know how to use F4 to do the change, but it is not an option when I have to deal with the addresses in a 150 row x 50 column table. Thanks, Wei

View more questions Search