This article presents a collection of simple and nifty Excel tools. What is called tips & tricks in English. In some cases, I provide a link to the original source. This only means that it was there that I first met the description of the method. Excel has an additional (alternative) drag- and- drop context …
Let’s share two very practical ways to split one row into multiple rows in Excel. 1. Application scenarios Some people may have questions. Isn’t it all rows of data by default in Excel? Do the rows of data still need to be split? Of course, if you encounter this kind of table data, which contains …
How to split one column into multiple columns in excel Read More »
Excel spreadsheets often work with a large amount of data, and when working with such volumes, when scrolling, it can be difficult to remember which column / row contains which data, so it is convenient to use the Freeze Areas tool so that the table header always remains on the screen and the table itself …
You are born. You insert a column. Brings the same format as the column next to it. You waste the rest of your life changing the format so that it comes blank. In the most recent versions of Excel (2007 onwards), the program decides that every time you insert a column / row / cell …
File mode incompatibility is usually caused by opening a file made by an old version in a new version of Excel. You only need to change the storage format of the file to solve it. The steps are as follows: 1. Click the “WPS table” column in Excel. 2. Select the “File” option in the …