close

i don´t know how to put in a formula the action that makes the shortcutkey
F9(gives another number in the cells with the function random)

F9 is the keyboard short cut for quot;Calc Nowquot; Go to Tools and Options then
the Calculation tab to see this option.

if you want to show a quot;randomquot; number when you press the F9 - the function
you are looking for is Rand()

quot;help me please i´m lostquot; wrote:

gt; i don´t know how to put in a formula the action that makes the shortcutkey
gt; F9(gives another number in the cells with the function random)

i know all that you wrote, but the thing i want to know is how i put that in
a formula for an entire sheet

If you understand VB, you can insert a button and assign the function
quot;Worksheet.Calculatequot; to it.

quot;help me please i´m lostquot; wrote:

gt; i know all that you wrote, but the thing i want to know is how i put that in
gt; a formula for an entire sheet

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()