归档: 2019 August 21
-
How to Paste Data Skipping Blanks in Microsoft Excel
Copy and paste is a basic operation in Microsoft Excel that should be familiar to everyone. But what if you need to copy a column of data with blanks to another column? If you copy it directly, the data in the target column would be overwritten by the blanks. You can also, of course, copy […]
-
How to Change the Color of a Picture in Microsoft Office
Working with Microsoft Office programs often requires you to insert pictures to make the documents more informative and lively. But the pictures are not always suitable from the beginning. If you aren’t going to use any of the graphics processing tools on the market, you can turn to Office itself which has some basic functions […]
-
How to Enter the Same Data in Non-Adjacent Cells in Excel
It’s not difficult to autofill multiple cells with the same data or text. But most of the existing methods require these cells to be continuous. In fact, entering the same data in non-adjacent cells is probably more common in practical terms. If you’ve also been in this situation, try this small trick: First, press the […]