Functions

Occasional Visitor

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

Victor

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.