[Affiliate]
Blog Stats
- 3,190,937 hits
-
Join 3,265 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Dense Ranking with Power Query - Unexpected Behavior and Workarounds
- Show number in thousand (k) or in million (M) by using custom format
- How to replace value with a value from another column in Power Query
- Power Query Challenge - Joining two tables fully
- Perform VLOOKUP with 2 lookup values
- Insert a text string into a specific position of another text string in #Excel
- Same day last year...
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Mouse Tips
[Video] – Swap cell contents with a simple mouse trick
It is super easy to move cells around by drag and drop. The standard drag and drop action however replaces contents in the destination cells. What if we want to preserve destination cells and just shift them up or right? … Continue reading
Quick Tip – Close all #Excel workbooks at once
Have you ever had more than 10 workbooks opened at the same time? Did you spend too much time to close them all one by one? If so, you will love this simple trick to close all workbooks simultaneously! The … Continue reading
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
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
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
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. 😛
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
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)
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
wmfexcel 