How can you fill information into all selected blank spaces in Google Sheets with just one click?

Question

Accepted Answer

Yes, we can use the Fill Down feature in Google Sheets to fill information in all selected blank spaces in just one click.

Select the cell with the information you want to fill
Hover over the bottom right corner of the cell until the cursor changes to a small blue square
Click and drag the blue square down to the last cell where you want the information to be filled

Accepted Answer

Select the range of cells that you want to work with (cells A2:A13 in this case). From the Edit menu, select Find and Replace. Alternatively, you can just use the CTRL+H keyboard shortcut.