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