Monthly Archives: July 2019

Do you random numbers stay the same when you copy and paste in Excel?

This is an extension of my previous post – Freeze a random result with mouse trick. In my experience using Excel, from Excel 2000 to 2010, and recently 365 (I’d never used Excel 2013 though), I have experienced the same strange … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment

Freeze a random result with mouse trick

Perhaps you have tried to use Excel to generate a random number for a lucky draw. That is easy.  For example, if you want to generate a random number, you can use the function RANDBETWEEN. =RANDBETWEEN(1,1000) This will give you … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments

How to sort bar chart in descending order?

Sound like a silly question, but it is a bit confusing indeed. One day, a friend asked me how to sort a bar chart in descending order.  I told her to sort the data. She replied: “I did.  The data … Continue reading

Rate this:

Posted in Chart | Tagged , | Leave a comment