Auto Fill and Flash Fill

Question 1

What is Auto Fill?

Answer 1

The Auto Fill is the easiest method to fill data automatically in the worksheet cells.

Question 2

How to apply auto fill?

Answer 2

To apply Auto Fill, start by filling data in one cell and position the pointer at the right lower corner of the cell. Now, the mouse pointer will change to a black “=” cross symbol, which you can drag down to fill data in the other cells.

Question 3

What is Flash Fill?

Answer 3

Flash Fill is a time-saving feature, which identifies the data fill pattern that you use frequently in a worksheet and then fills the remaining series accordingly.

Question 4

How to apply Flash Fill?

Answer 4

To apply Flash Fill, fill in the data in one cell and then click on the Fill drop-down arrow in the Editing group on the Home tab and select the Flash Fill option, or use the shortcut key Ctrl+E.

Question 5

Which type of source cells can Auto Fill work on?

Answer 5

If the source cell contains text, a number, a formula, a day, or a month, the Auto Fill feature copies the data from the source cell to the destination cells.

Question 6

What to type if using numbers when using the Auto Fill feature?

Answer 6

In case of numbers, type two consecutive numbers to fill the series when using the Auto Fill feature.