Excel tips

How to wrap in the cell of excel. As shown in the figure below, some letters are entered in a cell, but there is no automatic line break. We want to type the manual input and find that there is no line break but it goes to the next line of cells. It is really speechless. In fact, it is very simple to display a newline in a cell, that is, alt+anter. How to quickly copy the contents of a cell? If a column in an excel table is the same content, how do you copy the content at this time? Ctrl+c then ctrl+v, if so you are out! See the figure below for details. Click on the cell you want to copy, and move the mouse to the lower right corner of the cell you want to copy. After a black cross appears, hold down the left mouse button to copy the cell contents. There is also an attachment option after copying that allows you to copy only the text or copy and retain the format. Very convenient to say. What if a column is a date and we want to populate multiple date values ​​sequentially? It's easy, just fill in the date in the first column and copy it as you did in the previous step. Note that excel recognizes the date and automatically increments the date value. As shown below. Only the date in the red box is manually entered and other values ​​can be copied. Xiaobian recommended "Summary: those commonly used Excel skills" from this article [System Home] www.xp85.com