Tag Archives: Mouse Tips

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.  😛 Advertisements

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