Question

Which function is used for filling the complete cell with

* sign?​

Answer 1

$\huge\underbrace\mathfrak\red{answer}$

Press [Ctrl] + [Enter] and Excel will copy the respective formula to all blank cells in the selected range. This keyboard shortcut can be used as a quick way of filling a lot of cells or copying a formula into a range when it is entered, rather than copying it separately afterwards.