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

  • Thread starter Thread starter tripflex
  • Start date Start date
T

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!!
 
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!
 
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
 
you could right-click at the bottom, on the name of "Sheet1" and select
"select all sheets"
 
Back
Top