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 Ctrl+G and It will pop up a Go To box option. In the box, choose 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.
Was this article helpful?
Yes
No
Not what you're looking for?
You can join our group and post your questions, or submit feedback to our
customer service for support.
Join our Facebook Group
Online Customer Service
