Provides friendly Word processing, Spreadsheets & Presentation software.

|
Kingsoft Office > Support for Windows Office > A Quick Smart Way to Fill out the Tables in Spreadsheets

A Quick Smart Way to Fill out the Tables in Spreadsheets

Release Date: 04-10-13

In our daily practical work, when we make a table, situation as following often occurs. What we need to do is to fill out the same content as above, finally it can achieve effect like the right picture. But how can we do it quickly instead of filling them one by one?

fill out in excel

Step 1: select the area you want to fill out, then use"Ctrl+G" to call out the "Go to" box and check the "Blanks"option and Go to, finally close the box.

A-Quick-Smar-Way-to-Fill-out-The-Tables-2

Step 2: enter"="+"↑" in first blank cell(in the selected state), you will get content like following.

A-Quick-Smar-Way-to-Fill-out-The-Tables-3

Step 3: press"Ctrl"+"Enter" at the same time. You can achieve the effect you want as displayed at the beginning of this article.