How can I set values for a cell in every sheet of a workbook?

[tripflex]

Okay, after some great help from someone on here to the solution of my
previous question, i now have another one.

I have approximately 100 sheets in a workbook. I want to set the value of
cell C5 to same exact thing for every sheet.

Is it possible to do this without manually going into each sheet and pasting
the code?

Thanks!!

 

[Dave Peterson]

Right click on one of the worksheet tabs.
Click on Select all sheets
type the value in C5
right click on any of the grouped sheet tabs
Click on Ungroup sheets

This can be a very useful feature (like for what you want), but if you forget to
ungroup the sheets, it can be disastrous!

 

[Bernard Liengme]

Yes and it is easy
Click on the tab of the first worksheet to be processed
Hold SHIFT and click on the last worksheet
Your worksheets are now said to be 'grouped' - note how the tabs of all
grouped worksheets have the same colouring/shading
Type the value into C5
Click on the tab of any worksheet to ungroup
Check a few worksheets to confirm all went well.
best wishes

 

[beenhouwerij_danny]

you could right-click at the bottom, on the name of "Sheet1" and select
"select all sheets"

 

[tripflex]

Awesome, thank you so much! I love this forum it has saved me hours or work!