[Affiliate]
Blog Stats
- 3,028,945 hits
-
Join 3,888 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?
- 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
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Insert a text string into a specific position of another text string in #Excel
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Rename column names in a dynamic way with #Excel #PowerQuery
- Open an embedded Excel file during a slide show in PowerPoint?
- Send a cell content to Google search
- Perform VLOOKUP with 2 lookup values
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Copy and Paste
Copy values from Status Bar in #Excel 365
You probably knew it… In Excel, when multiple cells are selected, we will see basic statistics of the selected cells in status bar: This is a very handy feature. But did you know… this handy feature has a nice touch … Continue reading
7 Copy and Paste Tricks I wish I knew sooner in #Excel
Regardless of what we do with Excel, Copy and Paste is something we do on daily basis… or even hourly basis. š You may be thinking, every one knows Copy and Paste. Yes, probably. But is every one using Copy … Continue reading
Replace values in filtered ranges using Copy and Paste trick in #Excel
Situation: In a filtered range of data, we made few changes on the side. Then we want to replace the original values with the updated values. What action appear on top of your mind? Copy and Paste of course. But… … Continue reading
You think you know Copy and Paste in #Excel?
11 Excel Copy and Paste Tips and Tricks you should know Perhaps Ctrl+C and Ctrl+V are the pair of shortcuts you use on a daily basis.Ā And probably you learned that on the first day your learned Excel.Ā Nonetheless, do … 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
Copy chart formats to other charts in Excel
If you know Format Painter, the on top of your mind solution should be using Format Painter to copy Chart Formats to other charts. However, it doesn’t work… š¦ No worries. Copy and Paste comes to recuse!! Really?!
Interesting behavior of Copy and Paste
This sounds silly, I know.Ā To achieve what is stated in the above scenario, what we need to do is simply Select “January to March” from the slicer Copy the range C4:C9 Paste to C13 Then repeat the above steps … 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
Using Skip blanks in Paste Special
What the Skip blanks does? Have you ever had this question?Ā From my experience, 99.9% users (I work with) have no idea what it is or even are not aware of that option in Paste Special. Are you one of … Continue reading
The Clipboard can be useful occasionally…
According to study (which was conducted in a totally unscientific way with zero level of confidence…, i.e. my gut feeling), 100% of Excel users use Copy and Paste every time they work with Excel. š Ā However, 99.99999% of them never … Continue reading
Copy and Paste can do so much…
Answer to theĀ 5 little TipsĀ (tests)Ā ā Part 5/5 The task:Ā To sort the following dates in descending order. Ā Sound silly butā¦ The first thing you would probably do is to go to Data tab and then click the Sort Z to AĀ icon? … Continue reading
Go to Special + Copy and Paste do the magic
Answer to theĀ 5 little TipsĀ (tests)Ā ā Part 4/5 The task:Ā ToĀ convert ā1ā to āTickā in a table like the following one: Answer: Ā Copy and Paste with a simple trick ā¦ What? Not Find and Replace? Ā Yes, you may do it by using … Continue reading
Transpose Data (Static and Linked)
Answer to theĀ 5 little TricksĀ posted in the beginning of the year – Part 1/5 Transpose Data – Result is static This is actually a simple trick of using Copy and Paster (Special, Transpose). Ā See? It can be done in a … Continue reading
Posted in Excel Tips, Formula
Tagged Array formula, Copy and Paste, Find and Replace, Paste Special, TRANSPOSE
2 Comments
5 Little Excel Tips (tests)
First of all, Happy New Year of 2017! Ā Wish you all an Excellent year ahead! Let’s start the year with a simple “Game”Ā which I developedĀ for in-house Excel training in my previous company. Ā All participants wereĀ expected to have basic Excel knowledge. … Continue reading
Posted in Excel Tips
Tagged Copy and Paste, Date, Fill, Find and Replace, Paste Special
Leave a comment
Copy data from strictly-protected sheet
How to copy data from a range where you cannot select, due to worksheet protection? Here’s the situation: You receive a worksheet with data but not insight. Ā Well, it happens and you get use to it already. Ā You plan to … Continue reading
Copy and Paste table while keeping column widths
A simple trick (click) can save you lots of time. Below is a commonly seen scenario in my work life: A user wanted to copy a table to a new worksheet/workbook, whatĀ he/she normally did wasĀ CRTL C then CTRL V. The … Continue reading
Probably the fastest way to convert formula into value – CTRL C, CTRL V, CTRL, V
āCopy and Paste Valueā is probably one of the most popular actions taken by many people every day.Ā A probably fastest way to do so is definitely worth sharing. I learn this from a comment to the post (http://www.myonlinetraininghub.com/favourite-excel-shortcuts)Ā byĀ MYNDA TREACY … Continue reading
Posted in Excel Tips, Shortcut
Tagged Copy and Paste, CTRL C, CTRL V, Keyboard Shortcut, Paste Value
6 Comments
wmfexcel 