How To Print Specific Pages In Excel 2016. Insert comments on excel worksheets; Open excel > file > print > options.
Check the page number on the status bar to ensure that you're on the correct page. Click the print range button below. You can mention page numbers or page sections in the text box to print only specific pages.
The Print Titles Command Will Appear Dimmed If You Are In Cell Editing Mode, If A Chart Is Selected On The Same Worksheet, Or If You Don’t Have A Printer Installed.
To print only selected pages, follow these steps: You can mention page numbers or page sections in the text box to print only specific pages. Fit all rows on one page.
And Then Click Print Button To Start Printing These Specific Pages.
Move the insertion pointer so that it's sitting somewhere on the page you want to print. With this feature, you can also print only odd or even pages, current page, all. On the print screen, look for the pages text box, illustrated here.
Follow These Steps To Print Only One Page Of Your Document:
Display the print dialog box. Sub printoddeven() dim totalpages as long dim startpage as long dim page as integer totalpages = application.executeexcel4macro(get.document(50)) startpage = inputbox(enter starting page number) if startpage > 0 then for page = startpage to totalpages step 2 activesheet.printout from:=page, to:=page, _ copies:=1, collate:=true next end if end. Devices & printers > right click > printer properties > depending upon your printer, locate where you can create custom size.
Check The Page Number On The Status Bar To Ensure That You're On The Correct Page.
You will have to create the custom size in a particular printer (if that printer supports custom size) and while printing through excel, you will have to select this custom size. On the worksheet that you want to print, in the page layout tab, click print titles, in the page setup group. Excel provides three easy ways to print chosen ranges:
Almost Any Range Of Pages Can Be Printed With Commas Separating The Pages Requested And Hyphens Indicating A Range Of Pages To Print:
The first two methods work well for occasional printing but, if you need to print a specific range or ranges of worksheet frequently, defining one or multiple areas to print, significantly reduce the efforts. Fit sheet on one page. To print a range or group of pages, summon the print screen: