Altering Web page Order In An Excel Workbook

 In Excel 2003, you possibly can regulate the order through which the workbook pages seem. It will decide the order through which pages are printed when a whole workbook is chosen for printing.

You possibly can choose web page order that prints pages throughout the width of the doc first or down the size of the doc earlier than returning to the second "column" of pages. To view the default web page order or to change it, choose File > Web page Setup and choose the Sheet Tab. Use the radio button to pick out Down, then over or Over, then down for the printing order. These controls apply to the print order for a number of pages inside a single worksheet.

If you wish to regulate the place of worksheets inside a doc, you could achieve this by choosing the tab and dragging it to the place through which you need the worksheet to seem.

So as to add new worksheets to the doc, choose Insert > Worksheet. A brand new worksheet will seem. By default, new worksheet pages might be added to the tip of the looks order and might be given a default title when they're created. You possibly can rename sheets inside a workbook by highlighting the tab title and typing a brand new title. You can not give a worksheet a brand new title if you find yourself creating it. Chances are you'll solely rename it as soon as it has been generated.

In case your doc incorporates a number of sheets, the navigation controls might be enabled if the variety of sheets exceeds the room allotted for tab show on the backside of the worksheet. You possibly can regulate the room obtainable for tab show by grabbing the divider between the tab show and the left-right scroll bar on the backside of the window. Allocating extra room for the tab show will cut back the slider size and vice versa.