Double click on the hair-cross and voila you get a complete list of consecutive numbers. Repeat step 1 to 4 for each sheet. Click Go to Footer button.
Click on the box where you want to insert the page number.
Need a Roman number sequence for some task or just for fun. Double click on the hair-cross and voila you get a complete list of consecutive numbers. The first is by using a formula within VBA Visual Basic for Applications in order to generate invoice numbers for a single workbook. This method works only if the immediately preceding column is populated.