Print your Worksheet pages in the order you want
Excel Tip #018 Print your Worksheet pages in the order you want Did you know that you can print your worksheet pages in any order you want? Yes, instead of printing a worksheet as pages 1-2-3-4, you can print pages 4-1-3-2, or any other order you want, without having to reorganize your worksheet. You may have a simple solution, why can't we just change the page order and then print. That's a good answer but what if the worksheet is a client report and it is only in read only format. All you have to do is to hold down the CTRL key and select each area you want to print for each page, in the order you want them to print. In this example, let's say you need to print pages 4-1-3-2 in that order. Before you begin, you may want to save your workbook if you don't plan on keeping this new print order. That way, if you make any changes to the current print area, you can close and re-open your workbook without saving those changes. You may find it easier to do th...