Tag Archives: Mouse Tips

The proper way of copying worksheet in #Excel

It is not uncommon for people to copy entire worksheet to another sheet (be it on the same workbook, or another workbook, even a new workbook). Nevertheless, are we doing it the right way? Many people would do so by … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Do your 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 , | 10 Comments

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

Mouse Tips – Move cell to other sheets

If you have tried to move a cell from one sheet to another sheet by dragging it to the Sheet tab, you would be frustrated it just keeps you (going) DOWN.  😛

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Mouse Tip – Move cell with Shift Key

If you have read my post about Move Cells with Right Click, you should know it is possible. However for continuous improvement, we often look for faster way to achieve the same thing.  With a simple trick, you may move cells … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 6 Comments

Fill a series of month-end dates

In many cases, we may want to create a list of month end dates.  This can be done either by formula or Fill.  Either way, we should input the first month end date (starting date) manually. Using EOMONTH Syntax: EOMONTH(start_date, months)

Rate this:

Posted in Excel Tips | Tagged , , | 2 Comments

Move cells by Right-click Drag and Drop

How to swap adjacent cell quickly? How to insert new items in the middle of a table? How to move cells more efficiently?… by using mouse… Last week, I learned from Debra Dalgleish to convert formula into value by using mouse.  What … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 2 Comments