Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make a cell absolute
i would like to know how to make a cell in a spreadsheet absolute.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make a cell absolute
A cell is always absolute.
It is the references to a cell that can be relative and/or absolute, I.e the way Excel increments/decrements parts of the reference when the reference is copied around. HTH -- AP "Carly Aspden" <Carly a écrit dans le message de news: ... i would like to know how to make a cell in a spreadsheet absolute. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make a cell absolute
Carly, =$A$1,
$A$1 (absolute column and absolute row) $A$1 A$1 (relative column and absolute row) C$1 $A1 (absolute column and relative row) $A3 A1 (relative column and relative row) C3 Look in help under Switch between relative, absolute, and mixed references -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Carly Aspden" <Carly wrote in message ... i would like to know how to make a cell in a spreadsheet absolute. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make a cell absolute
To turn a formula in a cell to an absolute formula, click on the cell, then
click into the formula bar near the top of the menu bars and then press F4. Every press of F4 afterwards, changes the absolute to Row then Column then None "Carly Aspden" <Carly wrote in message ... i would like to know how to make a cell in a spreadsheet absolute. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make a cell absolute
Thank you a thousand times. I have been trying to remember how to put
absolute references within cells using the keyboard and could not remember. "Saruman" wrote: To turn a formula in a cell to an absolute formula, click on the cell, then click into the formula bar near the top of the menu bars and then press F4. Every press of F4 afterwards, changes the absolute to Row then Column then None "Carly Aspden" <Carly wrote in message ... i would like to know how to make a cell in a spreadsheet absolute. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i make a cell absolute
Just in case:
=abs(a1) will return the absolute value of the value in A1. Yeah, I didn't think so, but just in case that's what you meant... Carly Aspden wrote: i would like to know how to make a cell in a spreadsheet absolute. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make cell contents a reference | Excel Discussion (Misc queries) | |||
Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
How do I change a cell from absolute reference to relative referen | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel |