Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
F9 is the keyboard short cut for "Calc Now" Go to Tools and Options then
the Calculation tab to see this option. if you want to show a "random" number when you press the F9 - the function you are looking for is Rand() "help me please i´m lost" wrote: 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) |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If you understand VB, you can insert a button and assign the function
"Worksheet.Calculate" to it. "help me please i´m lost" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|