Thus, to get the sequential page numbers you want, you should either select the worksheets you want to print before issuing a single print command or you should display the Print dialog box (Excel 2007) or the Print settings (Excel 2010 and later) and specify that you want to print the entire workbook. If you print multiple worksheets at the same time (create a selection set of worksheet tabs before you start printing), then Excel prints the worksheets sequentially, one after the other, and numbers the pages sequentially as well. If you print just a single worksheet, Excel starts the numbering at page 1.
By default, Excel determines what it feels is the best starting page number when printing a worksheet. There are two approaches you can use to get the page numbering you want. Each time she begins a new worksheet the page numbers start at 1 again.
Valerie has a business need to get Excel to use sequential page numbers across multiple tabs in a workbook, but she can't figure out how to do it.
0 kommentar(er)
