changing a range of cells throughout a 5 page spreadsheet
 

I have a 5 page worksheet. Each page has approx. 50 customer name headings .
Each customer has a list of dates vertically, Nov-1 through Nov-30, for
example. Information is entered on each day. I need to change Nov to Dec
throughout not only the entire 50 customers on that page but all the other 4
pages as well. How do I do that?

changing a range of cells throughout a 5 page spreadsheet
 

If you have entered them as dates like 11/1, 11/2 etc.

Open Find and replace and
replace 11/1 with 12/1 for all matches after choosing workbook in the
'within' drop box

If you have entered as Text then find and replace Nov with Dec.

"Midwest Farmers" wrote:

I have a 5 page worksheet. Each page has approx. 50 customer name headings .
Each customer has a list of dates vertically, Nov-1 through Nov-30, for
example. Information is entered on each day. I need to change Nov to Dec
throughout not only the entire 50 customers on that page but all the other 4
pages as well. How do I do that?