In the print section, select “At the end of the sheet” using the comment dropdown.So, the better option is to print all those comments at the end of the pages. Sometimes when you have comments in your worksheet, it’s hard to print those comments in the same manner they have. You can print your comments in a smart way. The Second option, if you want to print your pages using horizontal order.Īs I said it’s quite useful to use the page order option when you have a large number of pages to print, you can decide which page order you want to use.The first option, if you want to print your pages using vertical order.
Go to File Tab -> Print -> Print Setup -> Sheets Tab.You can specify the page order while printing. Using “page order” option is quite simple. Read More: Dialog Box launcher of Excel Ribbon Page order option is useful when you have a large number of pages to print. Now, when you print your data, the heading row and left column will be print on every page. Columns to repeat at the left: Column(s) which you want to repeat at the left side of every page if you have any.Rows to repeat at the top: Heading row(s) which you want to repeat on every page.Print Area: Select the entire data which you want to print.Now in your page setup window go to the sheet tab and specify the following things.Go to “Page Layout Tab” -> Page Set Up -> Click on Print Titles.Let’s say you a have heading row in your data and you want to print that heading row on every page you print. This is one of the most useful printing options in excel. Further Readings Formatting an Excel Worksheet for Printing 1.
0 kommentar(er)
