How to Fill the Same Content in Spreadsheets

When you edit a table in Spreadsheets, you will encounter such situation. You want to fill in the same content as above. Instead of copying, pasting, or filling them one by one, this article will introduce a simple way to fill in the same content. The figure shows the situation.

Step 1: Select the area you want to fill the same content, then press , It will pop up a Go to box. In the box choose the option 'Blanks', and click Go to.

Step 2: Input ‘=A1’ in the first blank cell.

Step 3: Press simultaneously, you will get the same content without effort.