Copper Contributor

Hello, I am new to excel and I have a question.


How can you select multiple cells and give all of them the same function at the same time?


Kind regards


1 Reply

@victor900 Follow the steps.

  1. On Excel work sheet hit CTRL+G. In prompt window type your desired cells (See the scrrenshot).
  2. Harun24HR_0-1673750282990.png


  3. Then type your desired formula.
  4. Press CTRL+ENTER. It will automatically put same formula to all selected cells.