Tag Archive: Paste special

Articles sur le thème : Paste special

How to round in k$ without formula?

Write your numbers in K$ In Excel, you can easily display your numbers in kilo dollars K$ or million dollars (M$) with 3 methods. In this article you will find 3 techniques to display a result in K$ (or m$ for the millions]. Each technique have their own benefits and disadvantages. The last one is my favorite …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/how-to-round-in-k-without-formula/

Examples of Paste Special (All Options)

There are situations where a standard copy-paste destroys the presentation of your worksheet. To avoid that it’s better to use Paste Special. Principle of paste special Once the “copy” has been activated, you can display a specific dialog box that offers a wide range of paste options. To select Paste Special, just click on the arrow under …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/examples-of-paste-special-all-options/

Time Formats in Excel

In Excel, working with the time is not difficult but you need to know a few rules to avoid big mistakes. In this article you will learn these rules and how to manage time formats. Difference between date and time in Excel In Excel, hours are always a fraction of a day. So it uses …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/time-format-in-excel/