You can follow these steps:
- Write the formula in the first cell.
- Click Enter.
- Click Ctrl+Shift+End. This will select the last right cell used on the worksheet.
- Ctrl+D. This will fill the value in the remaining cells.
Source at Zyxware
You can follow these steps:
Source at Zyxware