How to autofill data

Created by Athan Romblon, Modified on Fri, 2 Feb, 2024 at 4:58 AM by Athan Romblon

Dragging to copy a cell value needs a bit of explanation because you'll use this one a lot once you've set up formulas in your spreadsheets.

By dragging the small blue dot (pictured below) in the bottom-right corner of a highlighted cell across or down a range of cells, you can perform a number of different tasks:

  1. Copying a cell's data to neighboring cells (including formatting)

  2. Copying a cell's formula to neighboring cells 

  3. Creating an ordered list of text data

Arrow pointing to small blue square in the bottom right of cell.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article