1. could you tell me how to sequentially number separate worksheets which have come together to illustrate there are 11 sheets each by itself sheet 1 of 1, how can i make them 1 of 11 2 of 11 and so on

2. what woud be the best formula to use e.g. excel has # ## some people use pages num pages control f9 etc.

but the first step is 1. and then 2.
thank you

Posted 3 years ago