Excel Tip: The shortcut 【Ctrl+E】 is useful
According to the existing data column information, to generate a new column of data, we will generally use the formula to achieve, in fact, with EXCEL’s auto fill function (Ctrl + E) can replace most of the complex formula to achieve!
Just create a new column, and then manually create a target result , then select it, press Ctrl + E, the software will automatically analyze/imitate and generate the remaining data, the specific results can refer to the following examples
There are more tips for you to discover, enjoy!