Now, the simple way is to select that range and use the option “print selection”. Let’s say you want to print data from some specific section of your worksheet.
You can use this option every time when you are printing your pages as it will help to align your data in a correct way. Vertically: This will align your data into the middle of the page.Horizontally: It will align your data into the center of the page.In “Center on Page” you have two options to select.Go to File Tab -> Print -> Print Setup -> Margins.So you can align them into the center of the page while printing. Let’s say you just have data in 10 cells to print on a page. This option is useful when you have less data on a single page. Now at every page, you’ll get your custom header/footer. Here you can select the alignment of your header/footer.Click on the custom header/footer button.Go to File Tab -> Print -> Print Setup -> Header/Footer.But with a custom option, you can use some other useful things as well. Well, normally we all use page numbers in the header and footer. You can apply a number of decent things with custom header/footer. But, one thing you have to take care that you can only adjust your data up to a certain limit. Using this option can quickly adjust your data into the pages you have specified. Second, specify the number of pages in which you want to adjust your entire data using width & length.First, adjust using a % of normal size.Go to File Tab -> Print -> Print Setup -> Page Tab.I’m sure you have faced this problem in excel that sometimes it’s hard to print your data on a single page.Īt that point, you can use “Scale To Fit” option to adjust your entire data into a single page. This is also a quick fix to print data in excel. Now, all the comments will be printed at the end of the sheet. 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)
