Can you please explain the use of F3 & F9 keys with examples

F9 is the Recalculate key. This is for when you have set
ToolsOptionsCalculations to Manual, you press F9 whenever you want to
recalculate your sheet. This is useful in very large sheets that have
many interconnected formulas that take a long time to calculate.
Setting to Manual allows you to work, uninterupted. With Automatic,
the sheet recalulates every time you change any value in any cell.

F3 is the Paste Name feature. Let's say you have a cell named
"CostOfGoodsSold" (InsertNameDefine). Somewhere else on the sheet
(or on another sheet) you want to reference the contents of that cell.
Pressing F3 brings up the Insert Name pick box. You simply select the
Range name you want and click OK. Your target cell now has the
formula: "=CostOfGoodsSold" and the cell returns the contents of that
named range. This can save retyping lengthy range names over and over
again.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=394531

see this url and park it somewhere
will be useful

http://www.cpearson.com/excel/ShortCuts.htm


=============
Ankur wrote in message
...
Can you please explain the use of F3 & F9 keys with examples