Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

Forum Discussion

Copper Contributor

Jan 14, 2023

Functions

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

Formulas and Functions

Harun24HR
Bronze Contributor
Jan 15, 2023
victor900 Follow the steps.
On Excel work sheet hit CTRL+G. In prompt window type your desired cells (See the scrrenshot).

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

Share

Resources