Shortcut key for new random number in excel
My book says to use f9 to get a new set of random numbers in excel. That doesn't work for me but Command + z works. Does anyone know a one key short cut?
iMac, iOS 10.1.1
My book says to use f9 to get a new set of random numbers in excel. That doesn't work for me but Command + z works. Does anyone know a one key short cut?
iMac, iOS 10.1.1
You are posting a question about the use of Microsoft Excel in the forum for Numbers (a spreadsheet program made by Apple). I suggest jumping on over to the Excel for mac forum to get specific help:
On my Mac with Office 2011, if an Excel cell has the formula =RAND(), you can use fn-F9 to generate a new random number. It will update all cells with =RAND(), not just that one. You need to use the fn key.
I do not know of an equivalent key combo for Numbers. Usually it is recommended to put a checkbox in a cell that you can click on, which will recalculate the spreadsheet, including generating new random numbers. Another way would be to copy/paste a cell. Copy it once, paste as many times as you need to generate new numbers. Basically, any change to the spreadsheet will cause it to recalculate and to update random numbers.
Now if only I could get Office 2011 to quit asking me to enter the activation code every time I want to use it. I think Microsoft is trying to tick me off so much that I pay to upgrade to the latest version.
you need to submit this to an excel for mac forum. This forum is just for Apples productivity suite, iwork.
Thanks
jason
This a Numbers (Apple software) forum. For Excel (Microsoft software) you should visit one of the many Excel forums.
SG
Shortcut key for new random number in excel