Choose from among the presets or choose Custom Margins to set your own.This option is handy if you dont want everything on the sheet to print.For example, you have two tables of data on the same sheet, but you want to print only one.From there, you can select certain rows and columns to repeat on every page of a multipage printout (such as a row containing column headings, for example).
You can scale to a certain number of pages (with the Height and Width lists), or you can set an overall scale percentage. For a better experience, please enable JavaScript in your browser before proceeding. I would like to print the entire workbook but retain the individual sheet page numbers. For example: Sheet 1 has 3 pagesSheet 2 has 2 pagesSheet 3 has 2 pagesThe page numbers would show: 1 out of 3, 2 out of 3, 3 out of 31 out of 2, 2 out of 21 out of 2, 2 out of 2I can accomplish this by printing each sheet individually but that is rather tedious with 140 sheets. In cell A2 if the value A then allow both positive and negative integers. I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |